SQL Server Views Articles

SQL Server T-SQL Performance Tuning – Views

In this installament of the TSQL Performance Tuning series we turn our attention to Views Views Used Within Joins or Where Conditions As a generic concept, an inner join with an object which has insufficient indexing will result in index scanning or perhaps a table scan which also applies for Views Impacts: • Much CPU […]

Performance Tuning with SQL Server Dynamic Management Views

Since SQL Server 2005, dynamic management views and functions have complemented, extended, and replaced the options by which DBAs and developers could get insights into the internal workings of SQL Server. However, these Dynamic Management Objects (DMO) seem not to be as widely adopted as one would expect after almost six years ago. It’s well […]