Friday 19 August 2011

More SQL Server 2008 performance tricks

1. Optimize for ad hoc workloads option

http://msdn.microsoft.com/en-us/library/cc645587.aspx

and http://sqlskills.com/BLOGS/KIMBERLY/post/Procedure-cache-and-optimizing-for-adhoc-workloads.aspx

image

2. New compression features in SQL Server 2008

http://www.sqlskills.com/blogs/kimberly/post/SQL-Server-2005-and-2008-Compression.aspx

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

http://msdn.microsoft.com/en-us/library/dd894051(v=sql.100).aspx

3. Filtered indexes

http://technet.microsoft.com/en-us/library/cc280372.aspx

No comments:

Post a Comment

How to find the last interactive logons in Windows using PowerShell

Use the following powershell script to find the last users to login to a box since a given date, in this case the 21st April 2022 at 12pm un...