While preparing for the 70-451 exam I took a look at a stored procedure at a client's server that was performing poorly. This client is in the process of upgrading from SQL Server 2000 to SQL Server 2008 and they now also wanted to improve this stored procedure.
Recently I had to change the collation of a database. That resulted in an error message: The database could not be exclusively locked to perform the operation.
Aimed at a Dutch audience: The second SQL Saturday in The Netherlands is on it's way! Be there on October 23.
Read more information at www.sqlzaterdag.nl.