Both actually. During the reindex a...

I was the reindex job that was...

Phil Parkin (5/16/2011)

---

An excellent question and one which has just diverted me...

Jeff Moden (5/16/2011)

---

And, just to say it out loud... Like Remi said, the TIMESTAMP datatype is for row versioning. It has absolutely nothing to do with a date or...

Ho ya I remember reading something about that 4 years ago. Does the W stand for wide?

Wow, so cool :w00t:.

HEY, RTFM.

If you don't want our help stop asking for it.

That script WILL work all the indexes that need to be reworked.

If you want to control...

P.S. It's also a good time to check for mismatch in datatypes. Sometimes you really need a relation but you need to edit 1 of the datatypes. That...

Might want to re-edit that one!

Backups DON'T grow...

Don't reindex the whole DB, only what...

I once built a script to make those but I don't have access to it anymore.

The idea is to scan sys.columns and sys.tables (linking with object_id).

Then search for patterns like...

Thanks for posting the feedback... will help someone else someday.

What's the difference between the 2? >>> never used ssis b4.

No way... full backup doesn,t write anything to the data files... it makes a copy in another file completely.

I'd check your maintenance plan for...