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'