Adam Machanic, Boston-based SQL Server developer, shares his experiences with programming, monitoring, and performance tuning SQL Server. And the occasional battle with the query optimizer.
December 2006 - Posts
-
I just want to wish everyone out there in the SQL Server community a happy, relaxing, and hopefully not at all productive holiday! I'm betting things will be pretty quiet here at SQLBlog over the next several days, but make sure to say with us--there's Read More...
|
-
A couple of days ago, Aaron Bertrand posted about a method for calculating medians in SQL Server 2005 using the ROW_NUMBER function in conjunction with the COUNT aggregate. This method (credited to Itzik Ben-Gan) is interesting, but I discovered an even Read More...
|
-
Hello, there! You’ve somehow managed to navigate your way through the blogosphere and into the 21st edition of Log Buffer . It’s fitting that this is the 21st edition, because that just so happens to be the legal drinking age here in the United States. Read More...
|