Tx, I'd still like a 2k5 confirmation... am I the only one with a retarded server??? Can't possibly be the case :w00t:

TheSQLGuru (7/21/2011)

---

You simply must make improvements to your schema/data to allow you to remove the ISNULL(A, B) = something. Not only is it a CPU burn, it also voids...

Ignacio A. Salom Rangel (7/21/2011)

---

Wrong.

I've had a DB that a tool like that said it could reclaim data from that was completely and totally unrecoverable, and the tool, when we...

I don't...

halifaxdal (7/21/2011)

---

Ignacio A. Salom Rangel (7/21/2011)

---

Thanks for letting us know. Do yuo thing then...

Ignacio A. Salom Rangel (7/21/2011)

---

Thanks for letting us know. Do yuo thing then that...

... and I have this in prod since last year so I'm sure it's safe and doable ;-).

Declare @MyVar INT = (Select Max(MyID) AS mID from dbo.MyTable);

Ignacio A. Salom Rangel (7/21/2011)

---

halifaxdal (7/21/2011)

---

Yes, it seems working. I can see all the corrupted...

Knowledge Hunter (7/21/2011)

---

Thanks Ninja.

But the stakeholders are only interested about the only the fragmented tables.

So I was trying to find out a shortcut of identifying the tables using DMVs since...

david.moule (7/21/2011)

---

:exclamationmark:

>>>Strangely when I run this code and do a select on the table I get 8 rows.

Yep, the code I ran was just a simple copy and paste...

I don't have time to waste making sample data so please take care of that.

Bottom right of the post page has en edit attachemetn button. If you don't see...

Read both of these :

http://www.sqlservercentral.com/articles/64582/

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

I've never seen that issue. Maybe the log is huge NOW because of the shrink and then will go back to normal, but I can't say for sure...

No idea.

Either way you need to fix it and the script I posted will do just that, and very well.

I usually don't bother with previous versions info like that when...