Thanks for a great question!

L' Eomot Inversé (2/14/2013)

---

Nice question. However, the explanation would have been better if it had pointed out that filters like this can be placed in the when matche/not matched...

Agreed. This question, though...

Correct on both counts.

Great question, Tom

I almost wish you had thrown in an option of '2012-04-01 10:00:00.000' to spice up the thinking a bit more. Of course, then I probably would have gotten...

I did explore this further yesterday and wondered about your apps architecture. You could create these global temp files (##ABC) and look through the tempdb.sys.tables table to locate them, but...

You could do this with SQL Server Integration Services (SSIS) running on a tight schedule (every few minutes?) or with SSIS and the FileWatcher task (available from http://www.sqlis.com),...

Never mind! Never mind! Found the problem. Me. A configuration error -- those where it appeared to not be working were in a database whose connection string I'd messed with...

Outstanding question.

Hugo Kornelis (1/17/2013)

---

For any query that uses more than a single table, you should always use the table prefix on ALL column references. (And because most table names...

Great question -- I wasn't even aware there WAS such a thing as the Ghost function. The question forced me to do some research -- thanks!

Revenant (1/9/2013)

---

Thanks for an easy question.

However, I noticed then if the QotD offers choice 'this will run' and 'this will not run', in most cases the answer is 'it will',...

Excellent question, and great explanation! Thanks!

Actually, it's now "Ekke...

Hot Lips!

Great question. Got a little education today. Thanks.