Interesting thought. A page is 8k, but memory may operate in extents. If you create a table, at a minimum, 64k is allocated, in that an extent is allocated. Other...

Any VCS system will do this, but will require some manual work and administrative enforcement. Not sure if any tools integrate with Crystal, but some 3rd party tools, XMSSQL, embarkadero...

Thanks everyone, glad you liked it.

As far as the CPU %, it is the system object.  Apologies!

Disk Q - A tough one and honestly,...

I'd suspect it will not let you allocate more than that. Shouldn't throw an error.

you can't

Boy it's been awhile. I think this was some system account for remote linked server type activity. I remember it being a little of a security hole.

There is an mdf in there (didn't look for the ldf). You can attach these to your SQL Server.

Is this through a maintenance plan? Might be hosed up. Check the schedules and be sure everything is enabled.

The EM count comes from teh index, usually the indexid = 1, so I'm not surprised there. I'd drop and recreate the index if you can. If the above doesn't...

Haven't run into this, but that sounds like it might be a bug.

Which checklist? I run this and compare to the last time I ran it.

I don't think so. I believe that stored procedure cache, and perahps internal structures (locks, connections, etc.) can consume memory that is not reported in the buffer cache.

I believe that WITH DROP_EXISTING will minimize the nonclustered rebuilds. It's possible if you just drop and then recreate the index for nonclustered ones to be moved more than once.

I'm assuming this is some sort of parsing routine, so I won't ask why you care. My guess is that + and - are not just characters, but operators as...

While I don't think it's a big deal, it is a possible security risk. Just one more attack vector that is open. You might want to be sure that their...