Tag Archives: Query Tuning

Expert Performance Indexing for SQL Server 2012

Expert Performance Indexing for SQL Server 2012 is written by Ted Krueger (@onpnt) and Jason Strate (@stratesql) – two guys who I’ve known for a few years now.  They’re fun and knowledgeable and if you ever run into them at … Continue reading

Posted in Books, SQL | Tagged , , , | 2 Comments

Microsoft SQL Server 2008 Internals

Microsoft SQL Server 2008 Internals by Kalen Delaney et al. Microsoft SQL Server 2008 Internals took me a good six weeks to finish as it had so much information to consume that I would often find myself reading for ten … Continue reading

Posted in Books | Tagged , , , , , | 2 Comments

70-451–MCITP–Designing Queries for Performance–Evaluate the use of Row-based Operations vs. Set-based Operations

Requirements Evaluate the use of row-based operations vs. set-based operations.This objective may include but is not limited to: row-based logic vs. set-based logic, batching, splitting implicit transactions My Take In this section we will go over some of the reasons … Continue reading

Posted in SQL | Tagged , , | 1 Comment

70-451–MCITP–Design Queries for Performance–Analyze Execution Plans

Requirements Analyze execution plans.This objective may include but is not limited to: execution order, logical and physical operators, join operators, minimize resource costs, compare query costs My Take Execution Plans are one of the best tools we have for investigating … Continue reading

Posted in SQL | Tagged , , , | 2 Comments

70-451–MCITP–Designing Queries for Performance–Optimize and Tune Queries

Requirements Optimize and tune queries. This objective may include but is not limited to: optimizer hints, common table expressions (CTEs), search conditions, temporary storage, GROUP BY [GROUPING SETS|CUBE|ROLLUP] My Take The task of optimizing and tuning queries is something which … Continue reading

Posted in SQL | Tagged , , | 4 Comments

SQL Server 2008 Query Performance Tuning Distilled

SQL Server 2008 Query Performance Tuning Distilled by Grant Fritchey and Sajal Dam approaches the task of maintaining and tuning an SQL Server in a methodical fashion, and I highly recommend it.  The book might take a little while to … Continue reading

Posted in SQL | Tagged , , | Leave a comment

Tables – one look only, please – Or using CTEs

This post is in response to a query which I had to investigate earlier in the week which dealt with a number of very large tables.  I had never looked at this particular routine before and was slightly appalled when … Continue reading

Posted in SQL | Tagged , | Leave a comment