Friday, 19 August 2011

More SQL Server 2008 performance tricks

1. Optimize for ad hoc workloads option



2. New compression features in SQL Server 2008

Also see this article for deciding on when to apply database compression and whether to use ROW or PAGE level compression...

3. Filtered indexes

No comments:

Post a Comment

How to by pass the Jaguary X-Type enter security pin screen after changing battery

How to bypass security code on Jaguar X-Type touchscreen Satellite Navigational units. Just hold the skip track, AMEM and PTY buttons ...