Fairfield PASS


Please sign up on our Meetup (click here) for this event. You would not want us to run out of free pizza would you?

We look forward to seeing everyone!

Next Meeting




Optimizing the SQL Server and Databases for large Fact Tables

  • In-Person @ 1 University Pl Stamford, Connecticut, United States (map)
  • 19:00 - 21:00 Eastern Daylight Time
  • Language: English


Featured Presentation:

Optimizing the SQL Server and Databases for large Fact Tables

Thomas Grohser, SQL Server Infrastructure Architect =tg=

A session full of demos 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 Mary Go Round query feature and find ways to bulk load data faster and learn how to load from an OLTP system with zero impact to it.

About Thomas:
Thomas Grohser for the past 23+ years has spent most of his time exploring the deeper inner workings of SQL Server and its features while working for entertainment, pharmaceutical and financial services industries. His primary focus is to architect, plan, build and operate reliable, highly available, secure and scalable infrastructures for SQL Server. Over the years he managed thousands of SQL Server instances processing trillions of rows taking up petabytes of storage. Thomas is a Microsoft Data Platform (former SQL Server) MVP.


Back to Top