Surely this only works because you have explicitly specified the database in your `EXEC` statement? What does `EXEC sp_who_new` do?...

Surely this only works because you have explicitly specified the database in your `EXEC` statement? What does `EXEC sp_who_new` do?...

I figured you were using the test data, but I meant, 'How do you get the stats about the scan count, logical reads, etc, for each table?', as per your earlier post. I might be being dense, but I only know how get the more-basic cpu time/logical reads/el

Off-topic; a couple of further points about the forum software... 1. It doesn't appear to send you to your post, when you submit; it always seems to take you back to page #1. This is especially noticable if your reply is #11, #21, etc. I posted my m

Where do you get the test harness from? I see a lot of people providing results like these, but I been doing these with a slightly-modified one from [http://www.sqlservercentral.com/articles/T-SQL/66494/][1]. Incidently, I also get 61,160 rows with:

RAND() BEGIN PRINT('...Bird #' + CONVERT(VARCHAR(MAX), @loop) + ' receives no fruits or grain') SET @loop = @loop + 1 CONTINUE END PRINT('...Inserting up to ' + CONVERT(VARCHAR(MAX), @max_grains_per_bird) + ' grains

So it does; I'm not sure how I missed that originally. That said, posting direct from the challenge might lead to a lot of duplicates questions, especially if there is not a list of recent/upvoted comments on the main page. We'll see how it goes...

The dearth of comments here suggests that this particular forum thread might be a touch harder to find than usual. Normally, there is a link to the thread in the challenge writeup...