SQL Server Performance for Developers

Download PDF

For the .NET programmer, Visual Basic programmer or PHP programmer, if you are accessing a SQL Server database there are some things you should know to performance tune your queries. Learn how to improve query performance with Indexes, how to properly use parameterized queries, using the query analyzer, and avoiding common SQL Server performance pitfalls.

PerformanceTuning

This presentation is a lot of fun. This is one of the few presentations where there is audience participation. Four luck participants will be selected to help simulate the work that SQL Server does when accessing tables structured with different types of indexes.

Download the presentation here:

PerformanceTuning.zip

If you are interested in performance, please take a look at the Database Heath Monitor.

 

SQL Server Performance Tuning Help from Stedman Solutions, LLCSQL Server Performance Tuning Tips

Stedman Solutions offers one day, three day and five day performance tuning packages to help get your SQL Server running faster. With the help of the Database Health Monitor, Stedman Solutions can help find the performance, CPU or I/O bottlenecks to improve the overall performance of your SQL Server.

Posted in DevTeach Tagged with: , , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *

*

Time limit is exhausted. Please reload CAPTCHA.