Hmmm .. I'm not too convinced on that as it's only certain data conversions that will work on the fly .. do you have a test example ?

whilst I agree the while loop replaces the cursor the operation is still the same and while loops often do not run better than cursors. The real answer is to...

there's been a number of threads on this in the last month or so. A transaction log grows when data changes, even on a temporary basis, update stats, index rebuilds...

I'm not surprised to be honest, in x years of being a DBA I don't think I've ever found anyone with baselines for their server performance, as I tune for...

reads  are page reads, note that the values inside profiler are likely to be different to what you see in QA. cpu is I guess cpu cycles and sould be...

my understanding is that it's aimed at 16 processor threads and above

In general terms there should be stuff on msdn and technet, some hardware vendors have articles on sql server and optimsation, e.g. siebel, HP. You can convert to pdf.

I would have...

I've never had to change owner of model, I assume sp_changedbowner doesn't work?

IF not I guess if you follow the process for moving the model database then when you re-attach...

note that using awe disables dynamic memory, YOU MUST set the max memory option, DO NOT use EM,  script it

e.g.

exec dbo.sp_configure 'min server memory',3750

exec dbo.sp_configure 'max server memory',3750

exec dbo.sp_configure 'awe...

the while loop is the alternative, although from a sql point of view a cursor and a while loop hold the transactions differently ( by default ).

It's a pain dealing...

depends how you're handling the email. putting the data into a temp table and placing the results via xp_sendmail is one method.

you only have one msdtc service. Think you'll find microsoft have it well documented.

I run servers with up to 32gb ram currently, with no worries. With 4gb ram you have two options, set the 3gb switch and leave memory dynamic. set pae switch...

yeah agreed,an audit table should be a heap ( with or without a clustered index - in the true meaning of a heap ) A fill factor of 70% will...

sorry closed the original window as I was posting, as you've not got much memory you should have memory settings to dynamic with the 3gb switch, please don't try to...