Performance of sys.partitions Aaron Bertrand investigates what makes sys.partitions slow and shows that the unsupported sys.system_internals_partitions is more efficient. Aaron Bertrand ◆ January 19, 2021 7
New Metadata-Only Column Changes in SQL Server 2016 Paul White investigates the new metadata-only column data type changes possible in SQL Server 2016 when using data compression. Paul White ◆ April 17, 2020 3
T-SQL Tuesday #65 : Teach Something New For T-SQL Tuesday, Aaron Bertrand (@AaronBertrand) gives a little detail on something he learned this week about altering a column from NOT NULL to NULL. Aaron Bertrand ◆ April 14, 2015 1
Schema Switch-A-Roo : Part 2 Aaron Bertrand (@AaronBertrand) goes into a little more detail about what happens to metadata when you use schema transfers behind the scenes. Aaron Bertrand ◆ April 30, 2013 5
T-SQL Tuesday #33 : Trick Shots : Schema Switch-A-Roo Aaron Bertrand describes a way to use ALTER SCHEMA … TRANSFER to refresh data with minimal disruption. Aaron Bertrand ◆ August 14, 2012 11