There was no need to repost the question in this case. I have requested that the other one be moved to the 2000 forums.

No replies to this thread please, direct...

Because of the way page allocations are done for very small indexes, they will almost always be fragmented. It's nothing to worry about, fragmentation is only a concern when you're...

Sure. Look at the join conditions and look for cases where two (or more) tables aren't related to each other in any way. Take this as an example

SELECT * FROM

...

What's the primary key of the Employee table?

Can you post the index definitions? If they are identical (same columns in the same order) they they're redundant indexes. It could be that they're not quite the same though.

SQL doesn't have table spaces. That's an Oracle concept. SQL has files and filegroups.

Are you working with SQL Server? If so, what are you trying to do?

SQL doesn't have table spaces. That's an Oracle concept. SQL has files and filegroups.

Are you working with SQL Server? If so, what are you trying to do?

Thang.Nguyen10 (4/7/2009)

---

Gila, thanks. I tried this script and it was running amazingly fast, however, just one small difference, I got 3736 rows. And your script gave 96...

And the audit table please. And the full trigger, since you said you stripped stuff out of it.

Yes, but that assumes that SQL's encountered the suspect page. If checkDB is...

If you disable it for batches, it invalidates the entire purpose of auditing, but then the trigger's only going to work for one row anyway. Your cursor is over the...

Jeff Moden (4/7/2009)

---

But then I saw it happen today. One of us made just the smallest snyde remark about helping someone on what was obviously a laundry list...

Well, it is documented...

How big is the index in question? (number of pages)

Please post SQL 2000-related questions in the SQL 2000 forums in the...