There are three types of temporary tables in SQL Server. The local temporary table, the global temporary table and the table variable.
Everyone of them has a use case and advantages and disadvantages.

First things first. Despite popular belief ALL three types are stored in tempdb. We will prove that so you don't have to ....

continue reading

 

 

There are many time and date formats in sql server with different ranges, accuracies, storage sizes and user defined fractional second precisions.

Below is a short overview.

....

continue reading