After restoring some backup of SQL database file, there were dizzying number of tables. Not 20. Not even 50 but close to 20 x 50 tables. I wanted to know the magnitude of the complexity of the database that I’d dealing with.
First I checked for any data constraint issues. Please refer to a previous blog post to do exactly this. Fortunately, none was uncovered in this particular case.
And second I wanted to get a sense for how much data is the database initially populated OOTB when a customer installs this particular software i.e. how many rows of data are in each table of the database.