Common SQL Server Problems: Invalid Length

This is another part in my series designed to offer guidance around common issues in SQL Server. Today, let’s talk about the all-too-common error: invalid length.

Tables with a SPARSE Column and Consumption

Precision and Scale II

Precision and Scale I

Sparse Column Storage

GUID in SQL Server​

This tip's objective is to present and describe several T-SQL examples for creating, using, and analyzing GUIDs and assessing their uniqueness.

Converting to Bits

Changing the PK - I

How to get length of Text, NText and Image columns in SQL Server

There is sometimes a need to figure out the maximum space that is being used by a particular column in your database. You would initially think that the LEN() function would allow you to do this, but this function does not work on Text, NText or Image data types, so how do you figure out the length of a value in a column that has one of these data types?

Implicit conversion from datetime to datetime2