L'actualité technique MS SQL Server en France (et ailleurs)

Transact SQL

Purging Data from a Large Table in SQL Server
Purging data from a table is a common database maintenance task to prevent it from growing too […]

1 mai 2025 dans Sites anglophones étiqueté Featured / t-sql / T-SQL Programming / Transact SQL par simple-talk.com

Elements of the SQL Server Update Statement
Introduction This article explores a very common construct in standard SQL and Transact-SQL – the SQL Server Update […]

11 avril 2025 dans Sites anglophones étiqueté SQL Server / sql server update statement / t-sql / Transact SQL / Update / update statement par sqlservercentral.com

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 […]

15 mars 2024 dans Sites anglophones étiqueté collation / t-sql / Transact SQL / TSQL / Unicode par sqlservercentral.com

GENERATE_SERIES() Breaks Minimal Logging
tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very […]

18 septembre 2023 dans Sites anglophones étiqueté bulk logged / Data Generation / Database Performance / GENERATE_SERIES() / Jeff Moden / Minimal Logging / software testing / t-sql / T-SQL Programming / Test Data / Transact SQL par sqlservercentral.com