Thursday, August 26, 2010

Using XEvents (Extended Events) in SQL Server 2008 to detect which queries are causing Page Splits

volatile table & staging table

A volatile table is defined as a table whose contents can vary from empty to very large at run time.

A staging table allows incremental maintenance support for deferred materialized query table.

Quick test for SAN throughput

backup database Trace_DB4DBA to disk = 'Nul'