Doh!, you're right Paul. I'd forgotten that.

Have you tried just a straight rebuild on one of these tables to see what is does?

Some people stink, Gail. I've had more than a few complaints as well. That's part of the reason why I include the disclaimer right away.

I suspect that your reorg is good enough, but you never know. I'd actually be looking to do this after an upgrade, since changes to the schema might move things...

I thought the Linux one was old, though perhaps it may be recycled in the future. 😉

I'm not sure I fault her for wanting her share of the marriage. Both of them are a little silly, however, as are many of the demands athletes make. They're...

NULLs HAVE been deprecated, haven't you heard. SQL 11 will have no NULLs, Start rewriting now, defaults required, blah, blah, april fools, new code, more work, etc. etc.

Thanks for this thread, and the question. Went over well today, I think

Paul White NZ (4/1/2010)

I looked for that...

I would hope no one sees a joke as a waste of time. It's intended in fun, and should have brought a smile to your face. If it didn't, perhaps...

Hey, disclaimer at the end was required. It makes the joke, to me. Without it, it's like no punch line.

Use dbcc showcontig to check fragmentation. There isn't logging for defragmenting.

Moved to SQL 2000

I believe the issue is that these are heaps. You need a clustered index on the data to defragment.

Is this a dedicated SQL Server machine? Typically you don't size on user count since any user can run any query. One user can use all resources on a server...

Are you using anonymous access to IIS? Typically you put the domain account and pwd in the IIS setup and it's not visible to users of the web app. You'll...

Grant, you ought to use that for an editorial. It's certainly something worth talking about.