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

SQL Server internal storage

Identify Tables With Dropped Columns
In my last article – What happens when we drop a column on a SQL Server table? Where’s […]

7 juin 2024 dans Sites anglophones étiqueté @SQLServer / Data Storage / DBA / DBCC PAGE / Drop Column / drop columns / internals / SQL Server internal storage / TSQL par sqlservercentral.com

What happens when we drop a column on a SQL ...
Short answer: The column is marked as ‘deleted’ and will stop being visible/usable. But, most importantly – The […]

26 avril 2024 dans Sites anglophones étiqueté @SQLServer / Administration / Database Administration / DBA / DBCC IND / DBCC PAGE / internals / SQL Server internal storage / Table Structure / TSQL par sqlservercentral.com