TSQL – Show how many rows were generated by Normalize

Sometimes people want to know how many rows of data were generated by BDNA Normalize.  This kind of question can be answered several ways…
do they mean, “How many pieces of software are there?”
do they mean, “How many rows were generated in the whole publish DB?”
do they mean, “How many total rows (including the NORMALIZE DB which is the scratch space for normalization) in all of SQL are generated by the act of normalization?”

Well, here’s a query you can run which will count all of the rows in all of the tables generated during a normalization run.

(this query tested on SQL 2008 R2 against BDNA Normalize 2.2.x)

CountAllNormalizeRows

email

Written by , Posted .