THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Best Practices » habits » CTEs   (RSS)
  • Bad habits to kick : using loops to populate large tables

    In my last post in this series, I talked about using ORDER BY <ordinal position>.  Today I'd like to talk about using primitive loops to generate a large number of rows. Okay, I will admit, in most cases you are doing this for a demo or proof of concept, and so speed / performance is not all that important.  But using a loop to ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on October 7, 2009
Privacy Statement