Convert Implicit and the related performance issues with SQL Server

I was a running a routine query using an equal operator on the only column of the primary key for a table and I noticed that the performance was terrible. These queries should have been flying because all I was doing was retrieving one row of data which should have been doing an index seek. When I looked at the query plan it was doing a scan instead. This tip shows you what I found and how to resolve the problem.

Finding the Causes of Poor Performance in SQL Server, Part 1

To tackle performance problems with applications, first use SQL Profiler to find the queries that constitute a typical workload: From the trace, spot the queries or stored procedures that are having the most impact. Then it's down to examining the execution plans and query statistics. You then see what effects you've had and maybe repeat the process. Gail explains all, in a two-part article.

Query Hints

Using SQL Server DMVs to Identify Missing Indexes

I can run the Database Tuning Advisor or examine the query plans, but is there any easier way to determine which indexes may be needed?

New component in SQL server 2005

Tips for tuning SQL Server 2005 to improve reporting performance

We are required to report from our SQL Server 2005 database. There are five or six tables regularly used for holding the reporting data, but these tables have five-to-seven million rows of data in them already. We need to use these tables consistently and our performance involving reporting is struggling. Do you have any tips to help improve it?

SQL errors and other failures fixed from the trenches

Solve your SQL Server error, problem or installation failure with this advice. Learn how to fix SQL performance errors and suspect data recovery problems.

Speeding up the Performance of Table Counts in SQL Server 2005

This article describes how the Object Catalog Views can be used to determine the number of rows in a table

Read/Write Unit

Performance Implications of Database Snapshots

Books online mentions that performance may be reduced when using database snapshots. I decided to investigate how severe that reduction could be.