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

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

Let me show you 2 simple queries to find the row count of all the tables in a Database. Some time back I shared a trick to quickly find th...

In this post I’ll show you a quick trick to find the rowcount of temporary tables in SQL Server. Imagine a situation where you are executi...

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

In SQL Server 2012 Microsoft introduced a new T-SQL function FORMAT.  This function returns a value formatted with the specified format and ...

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

In SQL Server 2012 and 2014 Microsoft introduced many new features and enhancements. In fact there were 14 new in-built functions introduced...

Today I’ll show you some different methods to run a DML operation like UPDATE in small batches for a large table.  Though I’m going to show ...

Today I am going to talk about one new feature that is been introduced in the SQL Server Denali.   And that is:  one interesting enhancement...

Today 2 of my colleagues from reporting team had this requirement. They had one table where Seconds were stored as INT and in report they wa...

In one of my previous posts, I discussed on how useful GROUPING function is while writing a ROLLUP/CUBE query.  One more way GROUPING fun...

In one of my previous post I showed you how to UNPIVOT multiple columns .  On similar lines I also wanted to write on “How to PIVOT multiple...