Aaron Bertrand in Performance

Normalize strings to optimize space and searches

While this article is specifically geared to SQL Server, the concepts apply to any relational database platform. The Stack Exchange...

Aaron Bertrand in T-SQL Programming

Working around schema drift in SQL Server

At Stack Overflow, our environment has multiple implementations of a largely – but not 100% – identical schema. (By “schema,”...

Aaron Bertrand in T-SQL Programming

When I first saw a bullet item stating SQL Server 2022 would support instant file initialization for log file growth,...

Aaron Bertrand in T-SQL Programming

I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server.…

Aaron Bertrand in T-SQL Programming

I have come across a lot of use cases for manufacturing rows on the fly, aside from the common goal...

Aaron Bertrand in Featured

I recently wrote about a way to generate visual, interactive calendars in HTML by combining a calendar table with data...

Aaron Bertrand in T-SQL Programming

I’ve been at this for a while now, and have a very particular set of rules and coding conventions that...