To coin another phrase: Much Ado About Nothing. It's just a phrase that some could mean that the data appears to be a mess and you can't make any sense...

This was so good they ran it a second time.

Cool, thanks, I'll give it a try.

I agree totally.

Thanks for the good article.

In the small state that I work in, 1 million of anything is a big number.

Thanks for the article.

Great idea, thanks.

If the queries aren't too intensive we just use production. For those over-the-top queries we use a recent backup in some staging type area, knowing that the data may not...

Thanks for the refresher on the OVER() clause.

I pretty much stay out of this area and just focus on data.

Still a good read even a year later.

TomThomson (10/17/2016)

---

Nice query, but one only has to check query 5 and query 4 to get the right answer, since only one answer option has 5 working and 4 failing....

This could be useful as we have a need to do this on occasion.

We have a need for this. Thanks.