Category: Articles
-
Day 1 – Trace Flag 3604 & 3605
Today I’m going to cover trace flag 3604 & 3605. These two trace flags are used to print information’s or output from DBCC commands. As far as I know these two trace flags are widely used to get output for DBCC IND & DBCC PAGE commands. These two commands will not print anything unless or…
-
Enable \ Disable Trace flags in SQL Server
Trace flags are required for temporary purpose to analyze server level characteristics or behaviors during a course of action. It helps the DBA \ developers to troubleshoot the server. I’m not going deep into trace flag as this article I’m going to cover how to enable or disable trace flag for an instance of SQL…
-
Create database command blocks GHOST Clean-up process
Problem: I was asked by a colleague that when he runs a create database statement with large initial sizes for database files , he was able to find the ghost clean-up process with SPID less than 50 ( system process) blocked by the create database statement by simply running the query sp_who2.
-
ColumnStore Index
What’s this? Columnstore index is a new type of index available from the future release of SQL Server known as Denali aka SQL Server 2011. Columnstore index helps data warehouse queries to execute faster than the normal indexes.This index is suited if the volume of data is high and same type of query is used…
-
DAC – Data Tier Applications
This is one of the new feature released with SQL Server 2008 R2. I know it’s late to cover this topic. It has greater flexibility and easy of implementation for database perspective. I could say it’s a build which has all database & instance level objects for implementation, just run the build and get the…