SQL Server

Dynamic SQL vs Stored Procedure

SQL Server

Dynamic SQL and stored procedures are among the most important SQL Server components. Both have...
Read More

SQL Server Index Backward Scan: Understanding and Performance Tuning

SQL Server

Table indexing strategy is one of the most important performance tuning and optimization keys. In SQL Server, the indexes (both, clustered...
Read More

Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer

Database administation, Perfomance Tuning, SQL Server

Recently, I came across an application that generated DB queries. I understand that there is nothing new about that, but when application...
Read More

Automatic Data Collection: Database Files and Logical Drives in MS SQL Server

Automation, Database administation, SQL Server

Introduction It is important for a database administrator to know when there is no space on a disk....
Read More
Close