SQL Server Performance Tips
This section of the site contains SQL Server performance tips and articles to help identify and resolve performance problems.
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...
The
autoshrink 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...
I can
investigate performance issues, get a big picture of the state of my servers, find out
what is causing all those deadlocks, and more.
