I'd have to see both execution plans, at the very least, to help more on this. Can you post those?

Nadrek (10/8/2012)

---

Hmm... I'll rate that one just below the two LiveCD ones, both of which should be considerably easier...

I don't think it really matters which one you use in this case. I'd probably go with a trigger, because I dislike complex constraints, but that's just a personal...

Nadrek, please add to your list, "Download using a disposable machine".

I have an older desktop PC that still works. I flash (image) the drive after a clean installation of...

Every DBA interview I've ever had, what they actually wanted was "master of all trades", but what they'll settle for is "jack of all trades, master of the ones that...

Artoo22 (10/8/2012)

---

Hi,

If you cast your VARCHAR(MAX) to XML then SSMS can display the entire contents in an XML editor window.

DECLARE @Cmd NVARCHAR(MAX);

SET @Cmd = CAST('/*' AS NVARCHAR(MAX)) + REPLICATE(CAST('x' AS...

I've actually had managers tell me to pad my estimates on how long something will take, "just in case".

I occassionally have something go over my original estimate, but not often....

You'll get an error message from the SQL Server engine if that happens.

If you want to do more with it, check out @@Error, and Bing/Google "sql 2000 error-handling" for numerous...

The problem will be the UI, not varchar(max) nor replace().

SSMS, for example, will cut off at 8k characters, when it's displaying the data.

Try this:

USE ProofOfConcept;

GO

DECLARE @Cmd NVARCHAR(MAX);

SET @Cmd = CAST('/*'...

Sent my copy over to him. Assuming USPS doesn't lose it or anything like that, should be there soon enough.

EdA ROC (10/5/2012)

---

Thanks!

sp_who2 should have had a bit in the BlockBy column showing your open transaction blocking your other update. Won't see it now, but you could reproduce it by...

2008. Since it touches on that, and you won't be able to use 2008-only features in any lessons/examples, if you use SQL 2005 with it. I don't think...

Are the two uses of the query identical? "Select * from MyView" vs just running the exact query in the view without modification?

If so, have you checked for blocking...

EdA ROC (10/5/2012)

---

It's known as UPDATE FROM, and it's typically used to update a table with data from another and / or update a table filtered by a join with...

You don't need to change the structure, so far as I can tell. Just modify my queries to use your tables. Instead of Calendar_Users, it's your DateSkip table,...