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)
  • Using Qure Workload Optimizer for SQL Sentry

    Last week at SQL Bits #8 in Brighton, England, SQL Sentry (my employer) announced its partnership with DBSophic, makers of the Qure workload management suite. Qure Workload Optimizer is a tool aimed at analyzing a workload and providing suggestions to improve the overall performance of that workload. These suggestions can range from adding and ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on April 21, 2011
  • Revisiting ISNULL, COALESCE, and the Perils of Micro-Optimization

    Almost six years ago--in November of 2004--I posted what would turn out to be one of my most popular blog posts in terms of number of reads, ''Performance: ISNULL vs. COALESCE.'' (If you're curious, the post is dated July 2006 because I was too lazyit was difficult to transition the publication dates over with the posts when I transferred to ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on June 30, 2010
  • What Happened Today? DATE and Date Ranges Over DATETIME

    A few days ago Aaron posted yet another fantastic entry in his Bad Habits series, this one discussing mishandling of date ranges in queries. This is a topic near and dear to me, having had to clean up a lot of poorly thought out code in the past few years. Aaron's post includes many examples, all of which boil down to the proper way to do the ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 20, 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 January 7, 2005
Privacy Statement