Details

Optimizing the SQL Server and Databases for large Fact Tables

Thomas Grohser
75
Enterprise Database Administration & Deployment
Intermediate
A session demonstrating how SQL Server startup parameters, trace flags and the create database and alter database command when used correctly for the underlying hardware can make scanning your fact tables much faster. We will also as a side effect explore the Merry Go Round query feature and find ways to bulk load data faster and how to load from an OLTP system with zero impact to it.

Accompanying Material

No material found.


Back to Top cage-aids
cage-aids
cage-aids
cage-aids