Hi Luke/Steve,

As a follow-up to the original question, if there are 4 Select Into statements all inside the Tran, does it lock all 4 tables at the beginning of the...

Thanks Luke.

That sums up what I was getting at (inserting more records into "parentTable" while working with the original list that got inserted into #temp that is still inside the...

Thanks Nitin, does it change your response knowing that we don't really run Ad-Hoc queries in our production environment? We have a second database that is refreshed from production...

A little tidbit that I found out about this script (and others that I run daily). This script appears to track data from when the SQL Server instance was...

Nevermind, guess I should actually look at the script and analyze it then I could answer the question myself....(NoSampleDays....). Woops!

Question about this script, what is the "DataGrowth" value? I would assume that it's how much the database has "grown" since (when)? I have a database that is...