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.
October 2006 - Posts
-
On October 20, 2004 -- two years ago -- I announced that I was considering writing my own query load testing tool . Clearly, my follow through on this promise has been incredibly delayed. But all is not lost, and I'm happy to report that I am true to Read More...
|
-
SQL Server 2000 included a very useful extended stored procedure called xp_execresultset . This XP had two parameters: @cmd and @dbname . @cmd was expected to be a SELECT statement that would produce a single column of output, each row of which would Read More...
|
-
When working with SQL Server 2000, I used to have this little trick I'd pull out after exhausting all other ideas for tuning a query. And I thought that my little trick was dead in SQL Server 2005, but thanks to fellow SQL Server MVP Rob Farley , I am Read More...
|