October 2007 - Posts

• T-SQL Cursors -- the Case of the Published TPC-E Tests

  Within the SQL Server community, there is so much publicity on T-SQL set-oriented processing as good practice and the use of T-SQL cursors as bad practice that T-SQL cursors are effectively being seen as a plague to be avoided when in fact it's not the Read More... Posted Tuesday, October 09, 2007 12:39 AM by Linchi Shea | 7 Comments Filed under: Performance, Best Practices, T-SQL

• Performance Impact: The Potential Cost of Read_Committed_Snapshot

  In response to my previous blog post-- Performance Impact: Setting a Database to Read Only , Shailesh Khanal mentioned that he observed significant performance degradation from READ COMMITTED SNAPSHOT OFF to ON for a read-only workload. This is counter Read More... Posted Friday, October 05, 2007 12:49 AM by Linchi Shea | 4 Comments Filed under: Performance, Best Practices, SQL Server 2005 Attachment(s): RCS.gif

• Performance Impact: Setting a Database to Read Only

  It is widely quoted that if a SQL Server database is set to Read Only (using ALTER DATABASE ... SET READ_ONLY), your queries may run faster because no locking occurs in a read-only database. This all makes sense conceptually. But I have not seen any empirical Read More... Posted Monday, October 01, 2007 2:50 PM by Linchi Shea | 13 Comments Filed under: Performance, Testing Attachment(s): ReadOnly.gif