Representing Money

Changing Data Types

Steve had to deal with a customer that changed data types in columns often. Is that something you experience?

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