SQL Server Performance Tips
This section of the site contains SQL Server performance tips and articles to help identify and resolve performance problems.
This website is no longer actively maintained.
However, I continue to write new articles at www.sqlcopilot.com,
where you can also get the latest version of SQL CoPilot FREE.
SQL CoPilot is the latest tool for the SQL Server DBA, used by major companies worldwide.
Now with SQL AutoPilot included for quick and easy SQL Server monitoring.
A fast SQL Server is something that should be taken for granted, but unfortunately the vast majority of systems do not perform well.
The reasons for this can vary, and include database design, hardware bottlenecks, poor coding, poor indexing, inefficient configuration,
and many more.
This section of the site brings together articles, hints and tips that may assist you in your troubleshooting, and can help to prevent
mistakes from being made in the first place.
This article explains why setting 'max degree of parallelism' to 1 is often beneficial to performance...
SQL Triggers are a powerful tool, but be careful not to overuse them. Inefficient trigger design can have a devastating
effect on application performance...
database option is OK in a development environment, but avoid it like the plague on your production servers...
OR condition performance is heavily dependent on correct indexing and efficient coding of the query...
SQL WHERE clause optimization is important to get maximum performance from a query. If an index exists on a column you obviously want the query
to use it...
Partition alignment is a well documented best practice, but does it have any benefit on an HP EVA?
The first of a series of articles on data warehouse performance. This article focuses on I/O...
This is a list of factors affecting SQL Server performance. This page will evolve over time...
Read more at www.sqlcopilot.com.