Same here... but it's still a little funny :hehe:.

Theory proven.

6.1 GB clustered index 99% fragmented.

4 GB log file, autogrow = off

ALTER INDEX REORG

DB IN FULL RECOVERY (might test bulk-logged later but not today)

Doing CHECKPOINT just to make sure...

Rhox (8/5/2011)

---

Ninja's_RGR'us (8/5/2011)

---

Hey Rhox I'd love to do a few tests with your particular case. Can you send me the table's definition (ddl to recreate it) along with the...

http://www.youtube.com/watch?v=RZ4YTg4S7HI

No it's not a joke (guy's wearing a funny costume).

I think you've just set a new records... checking into it ATM. 😀

pre-congrats :hehe:

Is it even possible?

@steve-2, what is the oldest post that didn't get answered? I can't...

That's got to be a new record!

http://www.sqlservercentral.com/Forums/Topic1076-5-1.aspx

Note this thread is almost 10 years old. I hope...

What the heck is this supposed to to? :w00t:

I personally preffer to create a new log file everytime.

3 diffs can be ok but it's actually a big overkill.

Over here we have "little" write operations to the db. ...

http://www.sqlservercentral.com/articles/T-SQL/62867/

Assuming the...

You have 1 easy way of voting. Take out that advertisement of yours.

If you keep posting here, just link to Jeff's vote instead. That's 1 massive vote...

Sure, use this instead. It'll beat the crap out of either of those jobs for speed and it won't be deprecated in future releases...

http://sqlfool.com/2011/06/index-defrag-script-v4-1/

As for your original question, not...

Mostly, I need another reason to set time aside...