Can you partition a temporary table?

Reading that title, you might sit and wonder why you would ever want to partition a temporary table.  I too would wonder the same thing.  That withstanding, it is an interesting question that I wanted […]

Indexing Just Got Easy

As a database professional one of the things that we should be familiar with is the use of indexes.  In SQL Server an index helps to improve query performance – when properly implemented.  There are […]

A Haunting TSQL Tuesday Tale

If you truncate a table, you cannot undo the action like you can with a delete.  What is the difference between the two methods to remove data from a table?