the total memory to each instance should be 2.5Gb

It's generally best to leave around 2gb of total memory when using awe.

with instances you must divide the available memory between them...

yeah, sorry can't help here - I just resolve problems from the SQL point of view.

I maintain that presenting the use of nolock as a tuning tool is both dangerous and missleading.

That there is a use for read uncommitted I will agree in certain circumstances,...

bit tricky as I don't have anything like this.. but .. if you're recording sessions, logging data etc. at a fairly high activity rate then attempting to delete ranges of...

filter by dbid , eliminate sql agent and any monitoring tools you have.

Choose sql batch as the event

if your views all start with a common prefix or have a...

the problem with that question is most of us don't get enough hardware and time to do that type of analysis. I suspect the quad will perform better. The amount...

absolutely! And I'd ban Access < grin > , no offence to the original poster, but I sometimes think that this style of thinking is the basis for so many...

generally best to use a test server, unless you have quiet times with no user activity then you could use your real box. It's like most things don't run on...

it's called a select list.  Ordinal positions are one of the worst practices along with select *.

If you need to structure your table it's not that difficult - data transformations...

you can do this through EM, I'd just script and recreate the table though, don't see why you're asking the question.

Like David I'm interested as to why?

I don't think it is - it's a couple of years since I did this - seem to remember I decrypted the procs on  a test db. I think you...

I'll repeat myself - at a bare minimum update stats and run dbcc updateusage after restoring/attaching a database. Other than thta I'd check network bandwidth , ntfs fragmentation, I'd also...

filegroups and av disk queue are not related. I personally never use disk queue , mainly because the values become meaningless on a san.

The best counter to use for...

The factor to remember with the cores is the per socket licensing cost, with sql enterprise this is significant. However a quad core ( which isn't a true quad but...

as I initially said it depends upon the data. I agree that sometimes a joined update will be better, however it just depends.  The simplest solution without changing the code...