This is the second part in a series of data warehouse presentations I’ve been giving. This one concentrates on the physical design of the underlying SQL Server database, some information on the SQL Server Fast Track Data Warehouse and finally a one slide guide to tuning the storage engine performance. The tuning slide is only really a first step and I plan a more in depth session some time in the future.
Also I apologize, this deck is a little word heavy. I prefer more graphics in a presentation but there is a lot of specific guidance to list here.
Page rendered at Friday, December 13, 2013 12:18:29 AM (GMT Standard Time, UTC+00:00)
The opinions expressed herein are my own personal opinions and do not represent
my employer's view in any way.