Thanks Grant, I will have to do some additional experiments as I am curious how this internal renaming/truncating of the #table works when you have concurrent executions using the #table....

Thanks for the information/assistance everyone. I like Eddie's rules too.

I found the following blog post from Paul White, which has helped clarify the situation and provide some context for...

Thanks for the replies, I appreciate it!

The heaps in question don't have a unique identifier. It seems best to me to put a clustered index on a...

It's a shame this guy's work was plagiarized.

I have been enjoying the window functions!

;WITH

cteT1 AS

(

SELECT 1 i UNION ALL SELECT 1 UNION ALL SELECT 1 UNION...

Disappointing to get the answer "wrong" when I answered correctly. Were we supposed to assume bugs were fixed, and give our answer based on the correct varchar precision?

+1

Good question though, as this is...

This may be due to the log initializing before the reference to the project connection manager. I am not sure why else the project connection wouldn't work. It's...

Hany Helmy (9/3/2013)

---

I have to disagree with this answer as per MSDN:

"After the database engine acknowledges that a transaction has been committed, its changes are persistent in the database";

Also...

Good question, thanks Tom.

L' Eomot Inversé (8/22/2013)

---

Nick Doyle (8/22/2013)

---

I don't agree that it encourages sloppy coding. You need to know how a language works and be a decent coder to not be...

I don't agree that it encourages sloppy coding. You need to know how a language works and be a decent coder to not be sloppy. I don't see...

Good question for this early in morning. Thanks

This depends on the query and your data. Can you provide more details?

The select from the table variable is at the end of the procedure, but the procedure is exited at the...

Thanks, easy question 🙂