Category: General
-
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…
-
New SSMS GUI Changes in SQL Server 2011 (Denali)
Im just writing this article to provide you the new changes to SSMS GUI available in SQL Server 2011 aka Denali. This article is not more into techie however it will just visualize you the changes made to SSMS GUI in .SQL 2011 Ill update this article whenever I see a new change in SSMS…
-
Adding Startup parameter made easy in Denali
You folks might have already know that a new version of SQL Server is on the way to market. Right now beta version of SQL Denali (aka SQL Server 2011) is released. In this version addition of startup parameter is made easy and effort less. In previous version we will be adding it in a…