BrentO @BrentOzar.com www.BrentOzar.com Brent Ozar @BrentO Let’s steal their hard work. An OLTP user says I want it to finish instantly A data warehouse user says I.

Download Report

Transcript BrentO @BrentOzar.com www.BrentOzar.com Brent Ozar @BrentO Let’s steal their hard work. An OLTP user says I want it to finish instantly A data warehouse user says I. 

BrentO
@BrentOzar.com
www.BrentOzar.com
Brent Ozar
@BrentO
Let’s steal their hard work.
An OLTP user says
I want it to finish instantly
A data warehouse user says
I want it to finish in 30 seconds
DWs
cache all data in memory (we can’t)
Maximize storage throughput to retrieve what isn’t cached
before you bother installing SQL Server
Type R
SQL Server 2012
Eval Copy
Hands-On Labs
mva
Get Certified!
@sqlserver
@TechEd_NA
#msTechEd
http://northamerica.msteched.com
www.microsoft.com/learning
http://microsoft.com/technet
http://microsoft.com/msdn