naga
SQL Server Performance Tuning : Table Variable Vs Temporary Tables
We have quite often used temporary objects (Table Variables and Temporary Tables) for setting aside...
Author: nagasuraj Date: 05/10/2015
SQL Server Performance Tuning : Per-Row and Per-Index Plans
One key operation done during a delete operation on a table is the updation of clustered and...
Author: nagasuraj Date: 05/03/2015
SQL Server Performance Tuning: Creating a Shell Database to tune your Production queries
On so many occasions have we encountered situations wherein during a performance issue on Production...
Author: nagasuraj Date: 04/26/2015
SQL Server Performance Tuning : Backward Scanning of an Index
One of the key areas to investigate during performance optimization is the indexing strategy. Not...
Author: nagasuraj Date: 04/19/2015
SQL Server Performance Tuning: Data Access Method
Writing Queries in SQL Server is not all that hard. But, writing Queries by understanding the...
Author: nagasuraj Date: 04/18/2015