SqlServerKudos - Bad habits to kick : using loops to populate large tables

Welcome!

SqlServerKudos is a place where you can find the latest SQL Server stories and articles to improve your skills and share your opinions.

Enjoy participating in this community and see which others are getting Kudos.

1
kudos

Kudos

Bad habits to kick : using loops to populate large tables

published 845 days, 22 hours, 58 minutes ago posted by

sa 850 days, 19 hours, 3 minutes ago

Bad habits to kick : using loops to populate large tables

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 populate a table with 1 million rows, one row at a time, is not fun at all, no matter how much thumb-twiddling you have to do. I often see people building up test cases like this:

category: News | clicked: 1 | | source: sqlblog.com | show counter code

tags: Best Practices, CTEs, habits, loops, numbers table

Border color:

Kudos Backcolor:

Kudos Forecolor:

Count Backcolor:

Count Forecolor:

Preview

SqlServerKudos