Browse by Tags

• Best Practices

• Multiple independent results from a single SELECT statement

  You cannot output multiple independent results from a single SELECT statement. But sometimes I wish that could be done. An extremely simple case is when you need to build the initial dimensions from a very large table. Typically, these dimension columns Read More... Posted Monday, December 12, 2011 4:39 PM by Linchi Shea | 4 Comments Filed under: Performance, T-SQL

• 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: Best Practices, Performance, T-SQL