Running out of drive space is a common reason SQL Server stops. sp_spaceused shows the Space Used by any table, with its row count and index size.
SQLAuthority News – Thank You to Awarding Author SQL MVP
Thank you for all the wishes on my SQL MVP award. It belongs to every reader here. Send me your ideas and I will publish them with your name on this blog.
SQL SERVER – 2008 – Introduction to Row Compression
Row Compression in SQL Server 2008 stores zero and null values without using disk space. Check the savings first with sp_estimate_data_compression_savings.
Trigger Overhead: Measuring the Hidden Cost of DML Triggers
Measure trigger overhead with controlled inserts, execution plans, and cached trigger statistics before moving slow work into a queue.
SQL SERVER – Deprecated DataType vardecimal
vardecimal, added in SQL Server 2005 SP2, saves space for zero and null values. It is deprecated in SQL Server 2008, where Row Compression covers more datatypes.
SQL SERVER – 2008 – Introduction to New Feature of Backup Compression
SQL Server 2008 adds Backup Compression. I back up AdventureWorks with and without compression, compare file sizes and show how to turn it on at server level.
SQL SERVER – 2008 – Insert Multiple Records Using One Insert Statement – Use of Row Constructor
SQL Server 2008 lets you insert multiple records using one INSERT statement with a row constructor. I compare it with separate INSERTs and the UNION ALL method.