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 1 of 2 (13 total posts)
  • PASS Summit 2011 - Zen and the Art of Workspace Memory - Demos

    What a rush. Standing on the stage in an almost-full 1,000-person room, I (very) momentarily wondered what I'd been thinking when I submitted a 500-level talk for the biggest SQL Server conference in the world. But despite a rough start--my laptop crashed and I had to reboot it two minutes into the talk--I found my rhythm and the entire 90 minutes ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 16, 2011
  • Where Can You Find Me the Rest of This Year?

    Autumn is creeping inevitably closer here in the US, and that means that speaking season is about to kick into high gear. Here's my current schedule for the remainder of the year:   September 8, 17:00 GMT (online) - 24 Hours of PASS webcast: ''Baseline Basics or: Who Broke the Database?''In this session, excerpted from my PASS Summit ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on August 21, 2011
  • TechEd 2011 - Performance Tuning and Optimization in SQL Server 2008 R2 and SQL Server Code Named "Denali"

    Thanks to everyone who took the time out of their conference experience to join Mike Wachal and me for yesterday's session on SQL Server performance tuning! For those who weren't there, we focused in on troubleshooting techniques, highlighting some of the key DMVs and new Extended Events features that will help with proactive diagnosis of ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on May 18, 2011
  • 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 job, ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on October 20, 2009
  • The Missing Indexes Feature

    Since I will be speaking about the Query Optimizer at the coming PASS Summit, I have been preparing my presentation and at the same time blogging about it. This time I will describe the Missing Indexes feature, seen from the point of view of the Query Optimizer.   We know that it is the job of the Query Optimizer to find an efficient ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on September 25, 2009
  • How the Query Optimizer Uses Statistics

      This post shows how the Query Optimizer uses statistics to estimate the selectivity of expressions during query optimization.   You can also use this as a second part of my last post, The Query Optimizer and Parameter Sniffing. Here I will show you the advantage of the use of statistics when the Query Optimizer can “sniff” the ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on September 3, 2009
  • The Query Optimizer and Parameter Sniffing

      As we all know, the SQL Server Query Optimizer uses statistics to estimate the cardinality and selectivity of predicates of a query to produce an optimal execution plan. The Query Optimizer accomplishes this by first inspecting the values of the query parameters. This behavior is called parameter sniffing and it is a good thing. Getting an ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on August 27, 2009
  • The Query Optimizer and Computed Columns

    In my previous post I talked about contradiction detection as one of the early steps in query optimization. Another interesting step performed during query optimization is the automatic matching of computed columns. Although computed columns have been available in previous versions of SQL Server, the automatic matching feature was introduced until ...
    Posted to Benjamin Nevarez (Weblog) by Ben Nevarez on August 10, 2009
1 2 Next >
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement