SQLSaturday 31 Chicago: Recap
Last weekend I had the distinguished pleasure of attending Chicago’s very first SQLSaturday event. Before I begin my recap I’d...
2010-04-22
650 reads
sqlchicken
SQL Server 2008 R2 Release Date: May 21 2010
R2 is ready to roll!
As expected, Brent “Master” Ozar (Blog | Twitter) already scooped the story, but it never hurts to...
2010-04-15
456 reads
2010-03-26
2,633 reads
2010-03-17
2,528 reads
Blogs
Renaming Files by Padding Numbers with PowerShell
By Steve Jones
Some time ago I had downloaded all the SQL Saturday XML files. I’ve been...
When do Statistics get updated?
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates...
Power BI: Making Date & Time Keys
By DataOnWheels
Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be...
Forums
Intermittent "nesting level exceeded" error
We're having a very peculiar problem with the "Maximum stored procedure, function, trigger, or...
Nested loop/HashJoin and left/right/full join
1. What is the difference among nested loop?hash join and merge join? 2. what...
Ask SSC