Ah, I see.

It's not so much that you're teaching me something new as you give me new/different ways to look at it and I thank you for that.

Thanks,

Chris

Gail,

Did you mean that at 50% your index would take twice the space on disk, rather than the table?

I use the general 90% fill factor on all tables because I...

The plan is for busy DBs to get their indexes defragmented once a week, by a scheduled job. Just part of maintenance.

Thanks,

Chris

I am a contractor here and do not have much knowledge being passed to me. I have to hunt most o fit down. I see no maintenance plans or third-party...

Well, thanks for teaching me something.

Chris

In my testing with BackupExec, several years ago, I found myself in the same boat as Lynn Pettis was saying. The tapes are too slow and tie up SQL Server...

I understand, but it just seems like it would be so simple, with small indexes, to just rewrite the index in the correct order so that there would be no...

Yeah, so I have been reading, since you mentioned pages in your last post. I vaguely remember reading smoething about that many moons ago but seldom run into an index...

5 pages in that index.

Thanks,

Chris

Turned out to be an oops on my part. It was a misspeling in the DB name and my eyes ain't what they used to be. The third time I...

Connection string. Dunno why I forgot that the first time.

data source=MGCAPSQL01\Develop;initial catalog=CBOCDiscrepancyReport;integrated security=false;persist security info=False;user id=cbodr;password=******;workstation id=MGBG1086;packet size=4096

I will work on getting a Profiler trace now.

Thanks,

Chris

Sorry, apparently I confused some of the code. I am using DBREINDEX, not INDEXDEFRAG, and it wil not accept an objectID.

After more research though, I don't think I am going...

It helps, but doesn't fox the problem. The problem is the Showcontig output, which gets pumped straight into the FragList table, then the data from that table is pulled out...

The individual objects, like when you need to duplicate a table real quick. Used to be simple to do with SQL 2000, you got the same window as if you...

I ran into this myself last week. Practically the same symptom you have, except I didn't reboot anything. The problem cleared up on it's own. In my case it's a...