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...

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...

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...

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...

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...

Date: 04/18/2015