I've seen that in production systems. Multiple times.

Probably the events your capturing.

Also,why...

Yup, the guy's right.

Please note that DBCC IndexRebuild is deprecated, has been so since SQL 2005. Use ALTER INDEX.

As for examining the code of DBCC Index Rebuild, you'd have...

Grant Fritchey (8/25/2014)

---

Instead of downgrading, I'd suggest tuning the queries and structures so that they perform better. There's not a massive known improvement in performance between most SQL Server versions....

It isn't. You can drop a unique clustered index. You can create a unique clustered index without the DROP_EXISTING clause.

Besides,...

Sapen (8/25/2014)

---

But a day/two's worth of data is in the 2012 database and I will have to do a data compare and move over the new records to the 2008...

Can't see anything wrong.

Make sure that the statement before the CTE (if there is one) is terminated with a ;

What error are you getting?

No. If you run a...

Then every single nonclustered index on the table will be rebuilt, they have to be...

You don't.

This is one of the flaws at looking at just perfmon...

Jeff Moden (8/23/2014)

---

Cathy DePaolo (8/22/2014)

---

I checked the execution plans of each, and they are the same. I am of the opinion that the subquery is not going to improve...

False.

Inplace updates are indeed performed. Any update which is not a key column...

Because a change to a key column (key of an index) means that the row must move from one page to another (indexes are logically ordered by their keys). If...

That was the post, I didn't remember exactly and couldn't be bothered looking.

I've said many times that indexes won't help poor *query* design and that indexes shouldn't be created where...