Key SQL Performance Situations to Watch Out For - Part One of Three
SQL Server is a very deep, robust software package, as are most enterprise class DBMS applications. There are many areas of functionality that work very well and are self tuning. However, with that much functionality at the disposal of the developer community, there are also many ways that features can be overused, misused, or abused. That being stated, there isn’t enough time with a single article to cover every possible conceivable performance situation that could arise. So, this article will attempt to focus on 3 of the most common SQL performance related issues that one will encounter in heavily loaded applications.