please don't multiple post

I've tried using written tests but I'm not convinced of their merit.

I usually drill into a candidates cv, especially if they claim expertise in a particular area ( for a...

I have av on w2k and w2003 clusters. The av only scans the local disks on the nodes.

There are a number of services which may be affected by the install, if you don't stop these services you need to reboot - snmp is one service I can...

There are a number of good books and training courses available.

I can recommend SANS  ( http://www.sans.org ) as a good place to find security - database design and security...

awe is a server setting not a database setting.

You should set /PAE and this will allow SQL Server to use the memory.

The 3Gb switch affects certain pools and it is...

Books on line might be a good starting point.

Output from a query can be output to a file through QA or dts

I usually add these to the startup parameters of the server ( click on server in EM, properties, startup parameters - I add 1205 too.  ( -T1204   -T1205  -T3605 )

To...

I have successfully removed public rights from most system tables and procs , however, and it's a big however, your applications may stop working, especially 3rd party apps < grin...

multiple data files only work ( from a performance point of view ) if each exists on a seperate disk or array. Generally multiple datafiles on the same disk/array will...

If your table does not have a clustered index it becomes a heap and any table level fragmentation will not be able to be removed, you can defrag the indexes...

grant datareader and datawriter to users/roles - no need to touch objects.  Or make them dbo < grin >

as far as I am aware table vaiables and temp tables are treated the same as physical tables by perfmon.

Yup to use more than 2Gb ram you need advanced server with enterprise sql server.

Changing a cluster name is fraught with problems, I speak from experience < grin >, moving the databases about is fine, I have 8 environments where we do this on a...