SQL Master

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