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.
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 [<my last name> @ pythian.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...
|