DBCC (Transact-SQL) Overview

SQL Server 2012 Posted from TechNet The Transact-SQL programming language provides DBCC statements that act as Database Console Commands for SQL Server. Database…

Keeping Indexes online while reindexing

This will also display the SQL Statement that is the offending blocker. Online index operations: Online index operations were added as an availability…

Viewing the execution plan for a specific Sproc

Views – 457

Using UPDATE STATISTICS

Updates query optimization statistics on a table or indexed view. By default, the query optimizer already updates statistics as necessary to improve the…