That works on all dbs on the same server.

Should be easy enough to strip out the create sp part and use that as a standalone script.

http://sqlfool.com/2011/06/index-defrag-script-v4-1/

DBCC TRACEON (1222,-1)

That will output the deadlock graphic in the sql error logs.

You could do a serverside trace that tracks the deadlocks as well.

Both work, but you can save the...

SELECT @mid = MAX(id) from basetable.

INSERT INTO basetable (fake identity, columns)

Select ROW_NUMBER() OVER (ORDER BY ClusteredIndeColumnsOfBaseTable) + @mid as Fake identity, Columns FROM @tbl

Then you need to choose the isolation...

You exemple is great to concatenate different columns of the same row.

What the OP wants is to contatenate the same column over multiple rows, grouped by the id.

That is what...

Trying to clear up the air :

You get the data movement error... when there's data movement. That means pagesplit or possibly if a record is moved to another...

powellstark (11/10/2011)

---

Reported as SPAM.

SQL Kiwi (11/10/2011)

---

OK...

bitbucket-25253 (11/10/2011)

---

Ninja's_RGR'us (11/10/2011)

--------------------------------------------------------------------------------

We're waiting on an OR & date. He's on top of the list. He needs an open heart surgery to fix 5 different problems. That's 10 hours on...

It was a known bug, confirmed by our own walking wiki from NZ.

SQL Kiwi (11/10/2011)

---

It is a bug, and one I have seen before. In the bad plan, the top branch index scan is unordered (it has the Ordered:False attribute). ...

Then lower it a little (leave at least 1 GB for windows). You can't starve the OS either. It's just as bad.

raotor (11/10/2011)

---

Ninja's_RGR'us (11/10/2011)

---

Your test env is underpowered.

Try reducing to 100 000 rows see if that helps. Going much under that is not going to be really a good test.

It...

Your test env is underpowered.

Try reducing to 100 000 rows see if that helps. Going much under that is not going to be really a good test.

It runs in...

GSquared (11/10/2011)

---

Ninja's_RGR'us (11/10/2011)

---

....

We're waiting on an OR & date. He's on top of the list. He needs an open heart surgury to fix 5 different problems. That's...

Steve Jones - SSC Editor (11/10/2011)

---

Ninja's_RGR'us (11/10/2011)

---

We're waiting on an OR & date. He's on top of the list. He needs an open heart surgury to fix 5...