WolfgangE (12/19/2012)

---

hi there,

with the appropriate version of SQLServer you can do the rebuild with the ONLINE-option so there would not be any downtime. Otherwise use the REORGANIZE-command instead of the...

GilaMonster (12/11/2012)

---

SQLSACT (12/11/2012)

---

sp_executesql is gonna use a plan that is already in the plan cache, whereas executing the batch on it's own is gonna generate an execution plan, unless you're...

Any chance of referential integrity between these 2 tables?

nidhis (12/11/2012)

---

Thank you. Also - the plan changes when I use the same batch using sp_ExecuteSql

I see there are no Key Lookups when I run the same query using sp_executesql...

GilaMonster (12/10/2012)

---

You see all the locks that are held.

If the select's session was holding an IS (from an open transaction and previous statements), that's enough to block the index rebuild....

I check sp_lock 88 when it was happening and it was holding a mixture of IX, IS key and page locks. If memory serves, sp_lock...

According to sp_who2, a select statement from the same table I was rebuilding on. It wasn't active though, it was in a sleeping state

I checked...

GilaMonster (11/29/2012)

---

A page is just an 8kb chunk of data. Given that, what exactly is the difference between a page (an 8kb chunk of data) and the contents of the...

One is a replacement of the entire page and one is the replacement of the contents of the page. To me, this seems like 2 different things, clearly in this...

GilaMonster (11/28/2012)

---

And...

Brandie Tarvin (11/28/2012)

---

"replace" is a poor choice of words...

Thanks Gail

Please don't get me wrong, I'm not saying that you're are being contradictory. There's obviously a huge difference between what you're implying and what I'm inferring.

The 8kb page in...

Grant Fritchey (11/28/2012)

---

Just remember that the number is an estimate. This means it can be wildly inaccurate. But, it's the only number you get, so you're going to use it,...

Thank You Gail

Please bear with me

On one of my posts regarding this, this...

Perry Whittle (11/28/2012)

---

SQLSACT (11/28/2012)

---

Could this possibly work:

>> Restore the Master database to another...