Blog Archives

MSSQL Table Variable Vs Temp Tables

Hello World! So I had been living in misconception-land and like a lot of people, I though Table variables in MSSQL were oh-so-great ’cause they did not involve a physical IO in tempdb. As it turns out this is completely WRONG!

Tagged with:
Posted in .NET, MSSQL

Execute SQL Batch queries using C# and SMO Magic

Hello World, Let me quickly summarize the objective of this post. We have a development database that is restored every night with masked data and schema from its production version. During the course of development, we need to alter the

Tagged with: , , , ,
Posted in .NET, C#, MSSQL

Finding out who is active with your MS SQL Server Database

Hello World,I was trying to research how to quickly (and easily :-)) find out what is currently active on a particular database instance and landed on this excellent post by Brent Ozar. He describes in a short, crisp video a

Posted in MSSQL

Avoiding Cursor in MSSQL server: The magic of set based operations

Hello World, Right, so it has been a happy new year so far. That helped push up my optimism to a level that every problem seemed to come with a solution : -) Now the problem I am going to

Posted in MSSQL
  • Comic for February 23, 2017
    Dilbert readers - Please visit to read this feature. Due to changes with our feeds, we are now making this RSS feed a link to