sysdatabases is still supported in 2005, can't offhand remember in sql 2008 as I don't use the backward views/tables. You can certainly find all that info - you could try...

It doesn't really work that way - I'm currently working on a 100TB+ database(s) or perhaps I should say how to scale/design the underlying system. Yes I've heard a lot...

you can extract the running queries from the dmvs regardless of who wrote it or where it is. I'd suggest you get the sql performance dashboard from connect, it's some...

there is no answer - or benchmark - you're asking the wrong question. Partitioning is a decision based upon scale ,architecture and application requirements. The performance, in a sense, is...

Most modern servers with a default install of w2k3 R2 do not require the /pae switch as DEP allows full access to the memory. set your max memory and set...

btw. I'd have 2gb for o/s as totally inadequate - 4Gb maybe, ideally 6GB

Is the o/s fully patched and up to date?

ditto sql server?

you cannot use dynamic memory management with x64 sql server, you must set a max memory at least and give the o/s adequate room - ideally around 6GB as a...

you cannot generalise in this manner, there is no correct answer to this question. I don't see how clustering has a part of this within this context.

When looking at consolidation...

1. no you don't need to recreate secondary indexes - I'd assume you'd have in place a routine to update stats, rebuild as required ?

most certifications only cover the version of sql server you take the exam for. It does make sense, and yes you need to re-take or upgrade your certification each version...

I'm guessing you mean you can't copy files with a direct sql command or by the agent. The service account used to run either/or the sql server engine and/or sql...

I was going to say that profiler does allow to run multi-threaded. The RML utilites will also do the job http://www.microsoft.com/Downloads/details.aspx?familyid=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en

but I found the documentation to be too vast...

I don't see the issue - put your logins on the new server and the replay trace will run fine.

I'm not sure you'll find a replay trace the answer however,...

2 - 3 % page file use is fine. SQL server will use allocated memory, 2.3gb free memory is fine - no worries there. free virtual memory relates to your...