From https://msdn.microsoft.com/en-us/library/ms175549%28v=sql.105%29.aspx:

(emphasis mine)

It makes some sense that...

Ah, my apologies!

I meant to respond to this last week and it somehow slipped my mind entirely.

So, the problem seems to be twofold.

First, SQL Server grossly overestimates the...

I should get a nickel or something every time I cite that Paul White article, since I seem to be continually going back to it 🙂

Read the article, specifically the...

If you're really adventurous (and the relevant log is still around, either in the active log or in a backup), you can get some information like that from the transaction...

Yeah, running that ALTER DATABASE command requires an X lock on the DB in question, so you effectively have to be the only session using the DB.

You could run it...

From the Paul White article I referenced earlier in the thread:

Dropping a temporary table in a procedure does not count as DDL, and neither does TRUNCATE TABLE, nor UPDATE STATISTICS....

Hmmm...that is frustrating.

I suppose you could read the log/log backup looking for the XactIDs mentioned in the xml or run a trace to see what batches typically precede those SELECTs,...

That is intriguing.

Does passing the 0x020000000b814f2b111b62d3b9a53282e0b2aaccbc90630b sql_handle to sys.dm_exec_sql_text just return the same SELECT statement?

Alright, life got busy, so it took me much longer to post the demo than I'd wanted.

At any rate, here's a demo of how the process works. So long as...

That indicates that the column companyname does not exist in the Orders table, which I believe is true in the normal Northwind schema.

To pull in companyname, you'll need to join...

Ah, I was in the middle of typing up a response and Gail beat me to it!

+1 to what she said.

Also, your BEGIN is missing an END.

Cheers!

Like Jason said, this is recorded in the default trace, so you can just query it to look for growth events.

Something like this would do the trick:

DECLARE @filename NVARCHAR(4000);

-- Current...

As I understand it, you probably should run CHECKDB against tempdb, since corruption can occur, and the files aren't zeroed out on restart, so the corruption can stick around.

Here http://www.sqlservercentral.com/Forums/Topic1025006-266-1.aspx,...

Well, you can't calculate exactly how much you need from PLE, which is why that's not how my process works 🙂

You can't really derive much from any of those counters,...

That error message suggest you've selected SQL Server Authentication and left the Login field blank. At least, that's the only time I've seen that error.

Cheers!