April 2009 - Posts

• What happens when you perform a rollback inside a trigger?

  A coworker who is studying for the MCTS exam for 2005 brought this question up and wanted help understanding why the answers in the study materials were correct.  After a few minutes of discussion, I decided this was one of those topics that was Read More... Posted Thursday, April 30, 2009 10:51 PM by Jonathan Kehayias | 3 Comments Filed under: Transact-SQL

• Clarification on SQL Server Deadlocks being Unavoidable

  While running through some of my personal emails tonight, I happened across two different questions regarding some statements I have made on forums post in the past, as well as in one of my articles on SQL Server Central : Even with "proper design" Read More... Posted Thursday, April 30, 2009 6:43 AM by Jonathan Kehayias | 2 Comments Filed under: Database Administration, Deadlock, Rants and Ramblings

• Update - SQL Blocked Process Monitor

  Due to dependency requirements I had to split this tool into two separate tools one for SQL Server 2005, and one for SQL Server 2008 today, and I have reposted the newer builds on the codeplex site: http://sqlblockedprocessmon.codeplex.com/ one build Read More... Posted Tuesday, April 28, 2009 10:18 PM by Jonathan Kehayias | 5 Comments Filed under: Database Administration, Miscellaneous

• New Codeplex Tool - SQL Blocked Process Monitor

  Update: Bug Notice!!! This app requires that you have .NET 3.5 installed and that you have the SQL Server 2008 SMO components installed for the alpha version to work. This was done by design, and is a shortcoming in my initial work that will be corrected Read More... Posted Monday, April 27, 2009 9:35 PM by Jonathan Kehayias | 6 Comments Filed under: Database Administration

• OT: Back to the grinding stone

  After nearly two months, I am finally back in Tampa, and working with SQL Server full time again.  I have a nice backlog, 1342 unread, of emails, as well as a backlog, 407 unread, blog posts in Google reader so I will be busy for the next few days Read More... Posted Monday, April 27, 2009 10:18 AM by Jonathan Kehayias | 0 Comments Filed under: Miscellaneous

• Clearing the Recent Servers List in SQL Server Management Studio`

  Update: While I was away, Aaron Bertrand already blogged about this topic on the following link: http://sqlblog.com/blogs/aaron_bertrand/archive/2009/03/18/managing-the-mru-list-for-the-connect-to-server-dialog-in-ssms.aspx also thanks to Don Keily for Read More... Posted Monday, April 20, 2009 7:49 AM by Jonathan Kehayias | 2 Comments Filed under: Miscellaneous

• Whitepaper: Troubleshooting Performance Problems in SQL Server 2008

  Microsoft released a new whitepaper titled Troubleshooting Performance Problems in SQL Server 2008 which covers how to troubleshoot common performance problems with SQL Server 2008 using existing features from SQL Server 2005 and some newer features specific Read More... Posted Tuesday, April 14, 2009 9:24 PM by Jonathan Kehayias | 1 Comments Filed under: Database Administration, SQL Server 2008