I agree with Roy that I might not use db_datareader/writer. If you have exceptions, you get into DENYs in roles and that gets confusing.

Create your own two role and assign...

You can easily add space to tempdb by right clicking the database in SSMS and changing the size of files if you don't have autogrow set.

any of these could work. I tend to like replication since it picks up by itself if the connection is down or delayed, but you need to administer it a...

Was just about to post what Gus did. You're confusing rows and columns a bit.

Since you have multiple rows with points, you get those results as rows returned if you...

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....