Good question. Demonstrates the requirement to explicitly cast a string value exceeding 8000 bytes as Varchar Max to prevent truncation. Thanks for the education.

I got it wrong, thought it was a trick question about aliasing transactions. I had forgotten you could do that, although it makes sense that you can now that...

Good question but IMO should have specified switch DATA from table to already partitioned table and DATA from partitioned table to unpartitioned table. I know it's pendantic but I've...

Christian Buettner (7/13/2009)

---

So I missed the "not" - verrrry tricky! 😀

If it was intended to be tricky, then I admit it was well done.

If not, I assume rephrasing to "ALLOW_PAGE_LOCKS...

Christian Buettner (7/13/2009)

---

I must be missing something:

Documentation states that

http://msdn.microsoft.com/en-us/library/ms188388(SQL.90).aspx

Also testing it directly in...

I'm a full time DBA who is capable of scripting and understands many of the intricacies of SQL Server but I still like and use maintenance plans. If I...

Well I'm confused. I'm currently studying for my MCTS in SQL Server 2008 and all the literature I have found up to this point suggests that instance support is...