I have to say I can't be sure without a hands-on, however the counter  AWE Lookup Maps/Sec   will indicate what is being used.

There may be other processes using memory, I...

You need sql2k ent + w2k adv server to make use of extra memory, without them your extra ram in your server is unused.

scope is local to the proc and you don't need to explicitly drop the table

The tables are similar and the basic principles can be applied to both 2k and 7.0. I usually move the msdb database onto the same data arrays as my oltp...

The quickest way is to delete data from each table within msdb on an individual basis, truncating those tables you really really don't need!  Don't have any active jobs running...

I have a procedure that takes 3 values ( = days history to keep ) for job history, backup/restore history and sys maint history. The proc just deletes from the...

http://www.dbassociatesit.com/

I've only worked with a dw upto 3/4 terabyte of storage, I had that arranged in 7 x raid 10 arrays.

Raid 5 has an added overhead for the parity...

well...............  all websites are official   we have  http://www.sqlserverfaq.com  for the UK user group for instance, it has offers and such for users.

Before the SSWUG started...

Well, clustering won't assist with backups or growth - it's purely a failover method to keep your server hardware available ( note the shared disks still represent a single point...

I trim all the history and backup tables in msdb every night, if you don't not only do you end up with an ever growing msdb but it does give...

I fail to see why the SSWUG charge as I doubt they have anything available that is not available elsewhere, and in some sense it goes against the whole idea...

SQL2k std can address up to 2Gb ram. When the server only has 2Gb ram you might want to set the max and min memory sizes to avoid starving the...

I keep a record, paper and electronic, of any issue and related references, that I come across as a DBA. This runs from server setup, how to move system databases,...

Preciously I always applied defrag to the o/s. As I didn't used std allocation blocks I couldn't use any usual tools. I found a utility on sysinternals web site which...

The tape drive problem is interesting - I wonder if the san storage drivers had a problem - the microsoft engineers reported a problems with poor disk response - I'll...