Transpose Query Output

script to return query result transposed.

Type conversions and Nulls

Date Difference

Oops! SQL column swap or SQL column clobber?

Silent Truncation of SQL Server Data Inserts

There are certain circumstances where SQL Server will silently truncate data, without providing an error or warning, before it is inserted into a table. In this tip we cover some examples of when this occurs.

Get Database Size

Know you database size

Question of the day

Identity Values

BIT data type

VARCHAR (MAX), NVARCHAR (MAX) and NTEXT Data Types

Despite NTEXT and TEXT being deprecated in SQL Server for some time they are still both used in production systems. In this article, I will briefly demonstrate the difference between a VARCHAR (MAX), NVARCHAR (MAX) and the NTEXT data types, and the impact on performance from using NTEXT/TEXT.