SQL-Articles

Data Engineering – Learn from the experts

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

  • July 2011 Month UG Scheduled

    We are back again this month. We are going to post pone this month UG a week , that is to first week of August.  You know why ? We have a fantastic SQL Server guest for UG this month. He voluntarily  wanted to take a session for Chennai folks. It’s none other than the…

  • 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…

  • What happens when permission is revoked in middle of work?

    This is one of the question asked by my friend and it seems very simple. I had a discussion with him and said that whatever the transaction it has started it will succeeded, however what I told him is not correct. I told him I’ll test it out and the answer which I gave it…

Got any recommendations?

Get In Touch