Adam Machanic, Boston-based independent database consultant, writer, and speaker, shares his experiences with programming, performance tuning, and optimizing SQL Server 2000, 2005, and 2008, in conjunction with related technologies such as .NET.
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...
|