Browse by Tags

• Agile Development
• T-SQL Performance
• T-SQL Programming

• Refactoring large live OLTP tables without downtime

  Refactoring tables does not have to be such a big deal. We do not have to shut modifications down, migrate all data into new structure, deploy modified modules, and do it all at once, while the system is down. Doing all migration at once may be risky, Read More... Posted Tuesday, January 03, 2012 1:11 PM by Alexander Kuznetsov | 0 Comments Filed under: Agile Development, Refactoring, T-SQL Programming

• Entering TRY blocks is not free, but still several times cheaper than catching exceptions.

  The overhead of entering a TRY block is relatively small, but the overhead of catching an exception is more substantial. If we manage to use CASE or IF to prevent an exception, we can noticeably improve performance. We shall run benchmarks and see for Read More... Posted Tuesday, July 26, 2011 11:15 AM by Alexander Kuznetsov | 9 Comments Filed under: Refactoring, T-SQL Performance, T-SQL Programming

• More specific queries may run faster, but we should not overdo it.

  It is well known that replacing a generic, one-size-fits-all query with several more specific ones may boost performance. However, in some cases these more specific queries do not perform any faster than the generic one. We shall consider several examples Read More... Posted Wednesday, July 20, 2011 11:01 PM by Alexander Kuznetsov | 0 Comments Filed under: Refactoring, T-SQL Programming

• Will wrapping up code in a reusable stored procedure hurt performance?

  In T-SQL programming, stored procedure calls are not free, and nested stored procedure calls cost even more. First, we shall prove it by running benchmarks. Next, we shall determine if the cost of calling stored procedures is high as compared to the rest Read More... Posted Wednesday, July 20, 2011 2:03 PM by Alexander Kuznetsov | 6 Comments Filed under: Refactoring, T-SQL Programming