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

Android mediaserver process killing battery life

If this happens to you, then do the following Force stop on Settings, Applications, All, Media Storage. Clear Cache and Clear Data, fo...