A second solution to my size of index table puzzle: Rama Mathanmohan’s query sums used pages from sys.allocation_units to give each index size in KB.
SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008
A reader’s job failed after upgrading to SQL Server 2008 because TRUNCATE_ONLY is gone. My notes on SHRINKFILE and TRUNCATE Log File, and what to watch for.
SQL SERVER – GUID vs INT – Your Opinion
GUID vs INT as a primary key or clustered index: I list one advantage and one disadvantage of each and ask you to add yours in the comments.
SQL SERVER – Attach mdf file without ldf file in Database
A friend sent me only his mdf file instead of a backup of the database. Here is how to attach mdf file without ldf file and let SQL Server build a new log.
SQL SERVER – 2008 – Introduction to Snapshot Database – Restore From Snapshot
A Snapshot database is a read-only, static view of a source database. I explain how it works and how to restore a database from a snapshot.
SQL SERVER – Data and Page Compressions – Data Storage and IO Improvement
SQL Server 2008 data and page compressions cut disk space and I/O. I explain ROW and PAGE compression and how to set them on tables, indexes and partitions.
Keeping Large Blobs Out of Your Main Tables
Large blobs can widen SQL Server access paths and backups; learn to separate payloads, avoid SELECT *, and measure off-row storage behavior.