The difference between BIN2 and Case-Sensitive collations in SQL
A common question that arises in SQL Server collation discussions is whether a binary collation (BIN2) is functionally […]
Transact SQL
GENERATE_SERIES() Breaks Minimal Logging
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very […]
One use case for NOT using schema prefixes
I’ve long been a huge advocate for always referencing objects with a schema prefix in SQL Server. […]
Performance Tuning with SQLFacts Tools
The need for performance tuning your SQL Server workloads has never been more critical. As workloads are moved […]
GENERATE_SERIES: My new go-to to build sets
I have come across a lot of use cases for manufacturing rows on the fly, aside from […]
Find 40 Problems in this SQL Server Stored Procedure
I’ve been at this for a while now, and have a very particular set of rules and […]
Petit guide de Transact SQL – Partie 1
Des types de données aux tables temporelles… Ce petit guide est constituée de 4 parties qui vont être […]
Getting started with ROUND() and Its Use Cases
In this article, I will explore one of the SQL Server mathematical functions, ROUND. The T-SQL ROUND() function […]
How to get IO statistics of SQL Server database files
SQL Server is a resource-intensive database system that requires adequate CPU and memory capacity to run transactions with […]
Generating Repeatable Sets Of Test Rows
In order to test graph structures, I needed a large set of random data. In some ways, […]