somewhere at the back of my mind is a thought that you need a compatible character set for whatever client you are using to view the data - you may...

this type of auditing is not simple to implement, I have used C2 but can't remember what impact it had on the server. There are some commercial products available, sorry...

There's lots of good microsoft white papers available on most subjects, but writing better t sql probably won't be one of them. You'll need a good sql book or maybe...

unless it is old hardware I don't see any reason why you'd want to use x32. As pointed out you would be putting a certain amount of risk into your...

you're all getting confused and muddled over files and filegroups. To improve read/write performance you can split your database filegroup into multiple files ( not filegroups ) based upon one...

the only real factor is if you get compile locking, this tends to only happen in fairly high repeat usage of the same proc - you can tell if you...

I really think BOL and a book on SQL would be a good place to start. Sorry but if you don't know join theory you shouldn't be let anywhere near...

sorry but a heap will fragment if it gets deletes and suffer page splits the same as any other table if conditions are right. You're thinking of a queue...

no matter how many tools you have you will still need the skills and undertstanding to interpret what is returned, if you can't do that then you're probably wasting your...

as long as you haven't enabled awe/pae or 3gb switch each instance will be limited to the 2gb address space. I'd suggest you allocate no more than 1Gb to...

yes, yes and yes. I still struggle as to why people still ask this years after this was first raised, especially as it is covered in serveral KB articles.

Generally stored...

you need to write your own query for this sort of thing - or get sql diagnostic manager which will do this for you. ( I have no connection with...

if you didn't restore a database or do anything which might flush the cache then you may have a problem. Depends on your setup and service pack

I don't see any issues, not that I've worked that many instances. You'll need to use the sql 2005 tools to administer 2005 fully, you don't have to install any...

at the end of the day you're best off probably writing much of your own stuff. I will give a plug for diagnostic manager, which I use, but essentially you'll...