Monthly Archives: June 2008

New Column in sys.dm._os_sys_info

There is a new column in the sys.dm_os_sys_info dynamic management view in SQL Server 2008, called sqlserver_start_time, which shows the last time SQL Server was started. I have a couple of sample queries below that show some of the other … Continue reading

Posted in SQL Server 2008 | Leave a comment

Improvements in Integrated FullText Search (iFTS) in SQL Server 2008 RC0

SQL Server 2008 RC0 was released to the public a couple of weeks ago, and we have been using it on a couple of Production servers for about three weeks. So far, I am pretty happy with RC0, especially compared … Continue reading

Posted in SQL Server 2008 | 2 Comments

My Own Walden Pond

I am spending a few days with a group of veteran SQL Server DBAs on the beautiful campus of Ohio University in Athens, Ohio, which was founded in 1804. It really is a wonderful setting, next to the Hocking River, … Continue reading

Posted in SQL Server 2008 | Leave a comment

SQL Server DML Triggers Are Evil

Conor Cunningham (formerly of Microsoft, and now with SQLSkills) has a good post up about the performance disadvantages of DML triggers.  I completely agree with him here. I am happy to say that we have zero DML triggers in any … Continue reading

Posted in SQL Server 2008 | 1 Comment

Cumulative Update Package 8 For SQL Server 2005 Service Pack 2 Released

Microsoft has released Cumulative Update 8 (CU8) for SQL Server 2005 SP2, which is a roll-up of all post SP2 fixes. It is Build 3257. This article explains the difference between the various types of patches that Microsoft issues for … Continue reading

Posted in SQL Server 2005 | 4 Comments

Activity Monitor in SQL Server 2008 RC0

Microsoft has finally taken the wraps off of a completely revised feature called Activity Monitor in the RC0 version of SQL Server 2008, which has been available to the public since June 10, 2008. If you have used Vista or … Continue reading

Posted in SQL Server 2008 | 9 Comments

SQL Server 2008 Jumpstart Material

Microsoft has posted quite a bit of new material about different new features in SQL Server 2008. There are lots of technically oriented PowerPoints, hands on lab documents and even VirtualPC Images that you can download.   Technorati Tags: SQL … Continue reading

Posted in SQL Server 2008 | Leave a comment