|
|||||
|
SQL Server 2012 Release Candidate is now Available from SQL Server Team blog The Data Scientist from BuckWoody 7 Scaling Strategies Facebook Used to Grow to 500 Million Users HighScalabilty 10 Sloppy Social Media Mistakes to Fix NOW from Hubspot Blog What is Hadoop? And Why is it Good for Big Data? from The Data [...] As some of you might be aware Paul Randal (blog | twitter) has just announced the launch of a new SQL Skills Community Mentoring program for a few individuals that took part in the SQL Skills Immersion Events. I’m deeply honored to be one of the select few that get access to invaluable advice from [...] This is the second time I’m writing a post in the “Meme Monday” series and this time it originates from Tom LaRock (blog | twitter). The topic is : What #SQLfamily means to me. This weekend I participated in a #SQLfamily reunion in Washington, DC. Some might argue that this is called SQL Saturday #96 [...] John Sterrett blog|twitter asked a question about “How do I loop by rowcount in SSIS? I have a table with 5 million IDs and would like to loop to process 10K at a time. #sqlhelp” This cannot be done natively in SSIS but you could create a stored procedure that uses the concept known as [...] I am deeply honored that I was chosen to present 2 sessions at SQL Saturday #96 in Washington, DC this Saturday, November 5, 2011! Location is: Microsoft MTC 5404 Wisconsin Ave, Suite 700 Chevy Chase, MD 20815 View Larger Map Subway: Friendship Heights Metro Station SQLSaturday is a training event for SQL Server professionals and those [...] I was selected to present a session Back to basics – How does the Algebrizer work has been selected for SQL Saturday #82 in Indianapolis, IN on Saturday, June 25, 2011! Location is: University of Indianapolis-1400 E Hanna Ave Indianapolis, IN 46227 View Larger Map SQLSaturday is a training event for SQL Server professionals and those [...] After attending a presentation on SQL Azure by Microsoft’s George Huey an interesting topic came to my mind in regards to the actual use for a cloud based database that has over 1400 incompatibilities with SQL Server: What’s the use for this since it is not a viable alternative to a production database. I would [...] As requested by Yavor Angelov from MSFT via Twitter im writing down what seem to to be my biggest pains with QO in SqlServer. 1) Whenever you have a a join between large tables QO will look at the indexes that exists on the join keys. If some indexes are missing it seems that the [...] I recently saw the worst example of how not to design a table and indexes in SQL Server. So here it is: Table1(UserID,ActivityID,ActivityType,AddDate) Role : Log any activity that a user is invited for. PrimaryKey: … Wait for it … tada : UserID,ActivityID,ActivityType,AddDate … Wait you say …. YES … all table columns are used [...] |
|||||
|
Copyright © 2012 Positively SQL - All Rights Reserved |
|||||