SQL Master

Imagine a situation when you are working on a query for couple of hours and suddenly your management studio is crashed or your PC is restart...

In SQL Server 2012 Microsoft did lot of enhancements in SSIS, especially by introducing the “ Project Deployment Model ”.  After this so ma...

Today I’m going to show you how to write a PIVOT query when column names are dynamic.  A dynamic pivot is very necessary when you don’t know...

Recently I was working on creating a custom dashboard to monitor the health of all the database servers.  One thing I wanted to add to the d...

Finding the row count of a table is probably the most frequently performed task by SQL developers/programmers.  So the obvious thing we all ...

Recently somebody asked this question on Stackoverflow forums “How many tables we can create on a SQL Server database”.  And I thought I sh...

Back in 2009 I wrote this post about How to Calculate the Running Totals in SQL Server.  Back then(before SQL Server 2012)  this was one of...

Many times you may have heard this “Use UNION ALL over UNION whenever possible.”  The question arises - why?  To answer this question in one...

I know this has been done many times, but still here is something from my side. What is the difference between DELETE and TRUNCATE? Wel...

Lets see how to find which Sql Server Version is installed and Service Packs applied on your machine- To know Execute SELECT @@version If y...

Lets see How to create a linked server with Excel 2007. Well most of the stuff you'll find on the net on how to create a linked Serve...