While both are created in tempdb, it is possible that both table variables and temp tables are memory resident as well

Jack Corbett (8/29/2011)

---

It's hard to say. It is very close, but the implementation is just different enough that it probably...

Anyone see plagiarism here:

http://www.sqlservercentral.com/articles/context_info()/74332/

http://www.thecodepage.com/post/TIP-A-Call-Stack-in-SQL-Server.aspx

Checked on Jeff's copyright issue. Simple Talk has given permission to that UK group, but I am unsure of there was permission given for Jeff's article. We are checking, though...

Will check on it. Bank holiday in the UK, so might be a day or two

Amazing. HEard about...

Added a note to the answer to specify encrypted databases. It's not necessarily wrong, but it makes the question better, I think.

Thanks, that's what we were hoping for.

It's a little hard to manage as we have 6 or 7 in progress, but we'll keep going and I've sent the XML notes...

WayneS (8/28/2011)

---

Jeff Moden (8/27/2011)

---

Gosh... outright theft of articles just keeps getting worse and even more blatant. Take a look at the following and then click on the Feb/Mar 2009...

Also, we have a free ebook on XSD here: http://www.sqlservercentral.com/articles/books/65843/

Jacob Sebastion has a great series on working with XML in terms of queries: http://www.sqlservercentral.com/articles/SS2K5+-+XML/3022/

In terms of indexes and other aspects of XML, I think you might have something here....

I don't see anything off the top of my head, but does this help? Give a better sample with names for parameters

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q194792

Jeffrey has great advice. Here's the licensing doc on the MS site: http://www.microsoft.com/sqlserver/en/us/get-sql-server/how-to-buy.aspx

http://msdn.microsoft.com/en-us/library/ms175574.aspx

The log file you want to delete cannot have active VLFs and it must be empty. So if you are in full/bulk logged mode, you'll need to backup the log,...

I look for tools that work. My iPhone has been far and away the most stable cell phone I've had (used WP6.5, Android 1.6, 2.0, Sidekick) and I think the...