Chad Petrovay

Tag: productivity

  • A Progress Bar for SQL Scripts

    A Progress Bar for SQL Scripts

    Last year, I was running cursors against massive datasets, and they seemed to run forever. It was like watching paint dry or grass grow, because, while SQL Server Management Studio shows the time elapsed and a running ticker of (1 row(s) affected) messages, there is no indication of what percentage of the dataset has been processed. So I ended up developing this progress bar in SQL to add to my scripts.

    (more…)

  • Accessioning Clean-up: Part 1

    Whether you are launching a data cleanup project or simply want to verify that standards are being followed, there are times you want to be able to quickly and easily manage your data. In 5 (Often Forgotten) Productivity Tools I mentioned that List Views are a great way to review data. In the first part of this tutorial, we’ll design a List Views to help with a project to clean-up accessioning information. (more…)