THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » Optimization   (RSS)
Showing page 2 of 2 (13 total posts)
  • The Query Optimizer and Contradiction Detection

    One of the many interesting topics I found while working as technical editor of the SQL Server 2008 Internals book was the concept of contradiction detection. So, in this post I will to try to expand on this topic and provide some additional examples.     Contradiction detection is performed by SQL Server during the early steps of the ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on August 4, 2009
  • Exploring the secrets of intermediate materialization

    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 officially reviving my trick from the dead here and now, in this blog post.... But first, ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 3, 2006
  • Controlling Stored Procedure Caching with ... Dyanmic SQL?!?

    Tell me if this situation sends a chill down your spine: You've written a stored procedure, tested it against a variety of inputs, and finally rolled it out in production. All is well... Or so you think. You start getting complaints from some users that it's taking forever to return. But other users are having no problem. What ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on July 12, 2006
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement