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.
April 2008 - Posts
-
I was just reviewing my calendar for the next several weeks and noticed that the Toronto SQLTeach conference is now only a few weeks away. This conference includes quite a few interesting SQL Server-related sessions , on topics ranging from best practices, Read More...
|
-
How creative are you with manipulating your queries to produce more efficient plans? Try the following puzzle and e-mail your solution to me at [<do_not_mail> @ do_not_mail.com]. Make sure to include an explanation of why it works, as well as your Read More...
|
-
If you've read many of my blog posts, you know that I consider lack of procedure cache control to be a major SQL Server pain point . Badly written apps that use non-parameterized ad hoc queries can quickly flood SQL Server's memory pools and bring the Read More...
|