Category Archives: SQL Server Internals

Sorting behavior

One of the best parts of my job is explaining database concepts to non-database folks: developers, managers, CEOs, my wife, etc. One lesson I’ve had to explain numerous times is that SQL Server doesn’t guarantee that data will come back … Continue reading

Posted in Business, DBA, Frustrating errors, SQL, SQL Server Internals, Testing | Tagged , , , | Leave a comment

Schema changes and row size

I was working on a stored procedure that was misbehaving on a rather massive and embarrassing scale. The code seemed solid. The data model made sense. And yet… Every time I ran this proc it crashed and burned. There were … Continue reading

Posted in SQL, SQL Server Internals | Tagged , , | Leave a comment