You are here
Home > 2010 > September

SQL Server 2008 Service Pack 2 Released

Some of my clients and I have been waiting on this for a little while – SQL Server 2008 Service Pack 2 has been released.  It includes resolutions for 21  issues and the inclusion of fixes for 61 issues previously resolved. Along with the resolution of those issues, Service Pack 2 includes a few new…

Index Black Ops Part 4 – Index Overhead and Maintenance

In my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part 3 – Index Usage…

Is It that Time Again?

Yes, it is.  As I mentioned a few months back, it is important to pay attention to when Microsoft releases Cumulative Updates for SQL Server. This past week, on Tuesday, Microsoft release an update to SQL Server 2008: Cumulative update package 10 for SQL Server 2008 Service Pack 1 If you haven’t, take the time…

Index Black Ops Part 3 – Index Usage

Last week, I mentioned in my TSQL2sDay index summary post, that I’d be writing a few posts on the information that is contained in sys.dm_db_index_operational_stats. The posts will be the following: Index Black Ops Part 1 – Locking and Blocking Index Black Ops Part 2 – Page IO Latch, Page Latch Index Black Ops Part…

Top