• Home
  • The Museum System
  • Business Intelligence
  • About Chad

Chad Petrovay

Tips and tricks for cultural heritage data management

Month: June 2017

SQL Scripting

A Progress Bar for SQL Scripts

Chad Petrovay 06 Jun , 2017 2

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 …

Tweet
Share
Share
Pin
Continue Reading

Tags

advanced query Alternate Numbers backup solution batch assign bibliography Collective Imagination Constituents contact details Crystal Reports data profiling data quality data scrubbing data security data standards dbconfig digital images end-user support Events freebie Function key intangible objects library system list view Location Authority Locations Authority Media Objects Packages permissions Photosynth preaccession productivity querying Reluctant DBA remote access security group slide deck Social media SQL View statistics status flags text entries training virtual objects webinar

Categories

  • Business Intelligence (6)
  • Data Governance (4)
  • Database Administration (5)
  • Miscellanea (2)
  • SQL Scripting (17)
  • The Museum System (25)
  • xperience Gallery (2)
Chad Petrovay All rights reserved.
Powered by WordPress Theme by alfisahr