Alter table or update dbo.table set...?

The reindex makes a 2nd copy of the index. Then once done swaps it into place. So while this is happening you need at least another 100% of...

https://connect.microsoft.com/SQLServer/feedback/details/383641/in-variable-concatenation-and-order-by-filters-results-like-where-condition

Why can't you have access to it?

3rd party?

No your only other option here is a cursor.

I'd try calling whoever is in control of it and ask for a copy.

Whatever else you can do here is going to be really slow (perf wise).

Welll #1 you'll need the whole procedure definition to create the 2nd procedure.

#2 With the tvp you'll have to edit every step in the query and chage where Col =...

Holly *&?() *N"/ )!"(&*/ *$?"/)$( &* _ $/(& $)/"(é

That's the polite version! :hehe:

Tx for posting this!

And then visible 😉

I know, but...

I've never bothered with repairing a disk. A new 1 is so cheap these days. Not worth my time to risk losing another db.

I've also always had this...

Unless Gails recommends a reboot don't do it. The situation might just get worse.

For NTFS you might also check each file separately (in case the permissions are not inherited)....

Jeff Moden (10/27/2011)

---

BWAA-HAAA!!!! Seriously? That's just unbelievable. What will someone think of next?...

Lee Crain (10/27/2011)

---

That's a shotgun criticism. Could you be a little more surgical? 😀

If you're educated about proper indexing, the information Performance Dashboard provides can be used in a highly...

Performance dashboard is fine if you can use more of a shotgun approach (throw a lot of indexes out there and then come back to see what sticks).

When the server...