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 replace the watch battery in Logitech K750 solar power keyboard

Buy this battery Open the battery cover on the back of the keyboard, you’ll need...