SQL Server Performance Tuning

Processor Performance, Update 2004

This article is a follow on to the original processor performance article I wrote, with analysis of processor performance results released in the last year. The original article explains many of details discussed here. Of the new material presented here: First, the range of results published for the TPC-C benchmark now allows meaningful analysis. Second, […]

A First Look at Execution Plan Costs in Yukon Beta 1

Many of us are interested in the features and changes in Yukon. A quick look shows some changes in the execution plan cost formulas for Yukon Beta 1. It is quite likely that more changes will be made between beta 1 and the final release. Most of the cost formulas appear not to have changed. […]

Advanced SQL Server Locking

I thought I knew SQL Server pretty well. I’ve been using the product for more than 6 years now, and I like to know my tools from the inside out. While teaching a SQL Server programming course, I noticed that the Microsoft material presented a lock compatibility table. The same table is presented at MSDN. […]

An Introduction to Clustered and Non-Clustered Index Data Structures

When I first started using SQL Server as a novice, I was initially confused as to the differences between clustered and non-clustered indexes. As a developer, and new DBA, I took it upon myself to learn everything I could about these index types, and when they should be used. This article is a result of […]

How to Perform SQL Server Row-by-Row Operations Without Cursors

SQL cursors have been a curse to database programming for many years because of their poor performance. On the other hand, they are extremely useful because of their flexibility in allowing very detailed data manipulations at the row level. Using cursors against SQL Server tables can often be avoided by employing other methods, such as using […]

SQL Server Connection Pooling Myths

Many of us are already familiar with connection pooling and understand to some degree its importance in web and SQL Server programming. We’ve all heard the adage that “connections are expensive” and “pooling is good”. This article will examine the topic in more detail, bringing to light some of the finer points of connection pooling. […]

SQL Server Hardware Tuning and Performance Monitoring

The hardware configuration that SQL Server runs on top of can make or break you. How do you know how much hardware is really needed by your applications? How do you know if your applications have grown to the point where they are now overloading your system?  In this article I will give you the […]

SQL Server Index Fragmentation and Its Resolution

While there is no doubt of the benefits of adding indexes to your tables, and for the most part you have to do little work to keep the indexes maintained, some maintenance is required as indexes can become fragmented during data modifications. This fragmentation can become a source of performance issues with your queries. So […]

An Introduction to SQL Server Query Tuning

During a recent interview to find a new job before my contract ran out, I was asked a question that took me by surprise. The interviewer simply asked me what steps I took to decide which stored procedures needed optimizing and what steps I used to optimize those queries. What took me by surprise was […]

SQL Server Application and Transact-SQL Performance Checklist

Return to Previous Article in the Series Performance Audit Checklist Transact-SQL Checklist Your Response Does the Transact-SQL code return more data than needed? Are cursors being used when they don’t need to be? Are UNION and UNION SELECT properly used? Is SELECT DISTINCT being used properly? Is the WHERE clause sargable? Are temp tables being […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |