we hate 'z' in the UK - long live 's'  - mind my spelling is suspect at the best of times!

the 64bit is interesting - that's also the way forward for sql server, cheers.

never never never ever ever ever enable autoshrink on a production database and probably never on any database.

You should attempt to balance the sizes of the mdf and ldf files...

re: poor performing views. Well to be honest the concept of using views to speed up a database is somewhat bizare - A proc will outperform a view ( for...

examining the query plan will give info on parallelism. I don't really understand the point of the question - if you want to control parallelism in each part of the...

hmmm .. I'd be slightly wary of the first and last references, the articles are not complete , in fact you'd probably fail an interview if you followed one route...

yeah, agreed on 3 & 5, I usually tend to ask questions which explore, hopefully, how a candidate thinks - questions without clear cut answers are good for that. I...

EM can be a bit of a pig - most likely the registration doesn't have sufficient permissions, try re-registering the server.

Also make sure you apply service packs to client tools...

I don't understand the significance of the post - if you can't answer these questions then you cannot be a dba and if it's in regard to an interview then...

The answer is the one that fits your situation .. I never take the blinkered approach as applications are often not ideal and thus "textbook" solutions do not apply. Beware...

think you're taking the wrong approach, indexed views materialise the data and thus can be used to effectively create multiple clustered indexes on a table, however materialising the data (...

Tricky things SAN's and tempdb !! OK, you'll never get decent disk queue stats froma SAN try using disk i/o completion time, this will show if the SAN is an...

The rules on indexed views are clearly stated in BOL, if you follow these you won't have any issues, imho attempting to use an outer join in an indexed view...

yup totally agree, I'm tuning a production system where the server is outsourced and that's exactly where I started, sadly it's taken a number of weeks without success, and I've...

I don't wish to sound rude but running a profiler trace and setting options not understood seems a bit strange to me. You might try the SQL 2000 Performance tuning...