Viewing 15 posts - 34,936 through 34,950 (of 39,723 total)
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...
May 11, 2004 at 7:54 am
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...
May 6, 2004 at 12:35 pm
Thanks everyone, glad you liked it.
As far as the CPU %, it is the system object.
Apologies!
Disk Q - A tough one and honestly,...
May 5, 2004 at 9:52 am
I'd suspect it will not let you allocate more than that. Shouldn't throw an error.
May 3, 2004 at 1:39 pm
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.
May 3, 2004 at 1:36 pm
There is an mdf in there (didn't look for the ldf). You can attach these to your SQL Server.
May 3, 2004 at 1:35 pm
Is this through a maintenance plan? Might be hosed up. Check the schedules and be sure everything is enabled.
May 3, 2004 at 1:34 pm
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...
May 3, 2004 at 1:33 pm
Haven't run into this, but that sounds like it might be a bug.
May 3, 2004 at 1:32 pm
Which checklist? I run this and compare to the last time I ran it.
May 3, 2004 at 1:31 pm
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.
April 30, 2004 at 3:08 pm
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.
April 30, 2004 at 2:51 pm
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...
April 29, 2004 at 1:20 pm
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...
April 29, 2004 at 1:15 pm
Viewing 15 posts - 34,936 through 34,950 (of 39,723 total)