ggraber (12/10/2008)

---

Jeff,...

Thanks for the feedback and the link, Madhivanan.

I already did such a comparison in Part 1 of this series, Goldie. 😉 Of course, I don't mind if someone else does a head-to-head comparison.

Heh... nah... I've got a couple of folks like that at work... they're actually pretty nice if you can get them to stop talking about their damned hump! 😛

I concur... haphazard formatting is tough on anything that expects a consistant format. OPENROWSET and Text Linked Servers do a pretty job job there.

Of course, when you have haphazard...

Garadin (12/10/2008)

---

Egad I hate those commas on the left.:hehe:

(I know I know, it makes it easier to comment out lines and such, but I still hate it)

I do put each...

Shoot (no pun intended)... it was the counseling that caused the disorder. 😛

Amazing story, indeed. Lynn is lucky to be alive never mind without having any broken bones.

Me? I'd have just shot the car. 😉

Thanks for the feedback, Pat......

Nah... I'm with ya, Jeff. Temporary insanity on my part. Ignoring the dupes is intentionally destroying data in an unaccountable fashion and shouldn't be used. Sorry I...

madhu.arda (12/10/2008)

---

Hi Jeff,

Iam curious to know why the available space for the database was showed as zero in enterprise manager and negative value when I ran sp_spaceused before running DBCC...

Nah... the worst posts ever (there were 2 at the same time) both beat 209 by a mile. Remember {shudder} "Bankers Rounding"? Even some of the good guys...

No "fiddling" required... it's set it and forget it. 😉

... heh... or some very high velocity pork chops fired at point blank range. 😉

That method using insert/rollback is a great place for more RBAR to occur... and it takes twice as long... 1 period for an insert... 1 period for a rollback... and...