I think you're missing the point and trying to be trendy by waving the green flag.! The main purpose of a backup is to enable yourself to recover from a...

I apolgise for just pasting a link, but I don't think we can answer your question in a simple post and Kimberley's white paper has to be one of the...

I'd suggest you do not use any switches but leave it as is. There are some o/s settings which may be useful - part of something I blogged just recently.

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/03/12/things-that-may-not-be-right-on-your-sql-server.aspx

in general seeing the query still doesn't help - you'll need to examine the query plans from the two machines to see the differences.

You should make sure your stats are...

Can you confirm you have 4Gb of ram ? or a typo? If you only have 4Gb ram I seriously suggest you don't enable the 3gb switch and...

just to cheer you up, experience shows that many SAN vendors and partners have little ability to correctly set up a SAN for SQL Server - there have been several...

have a read of my research and testing - it may help http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/01/06/configuring-windows-2003-x64-for-sql-server.aspx

I'm also currently working with a very busy sql2k setup and that's been interesting to say the...

in general terms your question is too vague and we could make so many suggestions, most would probably be wrong.

I'd take a first guess at parallelism causing slowdown - but...

it's unlikely changing the block size will actually have much visible effect - I've never been able to measure any; however, I agree that 64kb for t logs is vital...

The amount of physical memory for sql server is unlikely to affect parallelism. For an out of the box sql server the only deciding factors on parallel plans are the...

I hate to disagree but you're both wrong. I've done extensive testing trying to see a performance drop on maintaining indexes for inserts at least. I generated around 2,000 rows...

I posted a custom rdl which does this - the query is a bit more simple. I don't usually create views or procs for this type of work as I...

do you have set commands in your function?

partitioned tables can be a bit odd in joins - tricky for us to advise - I assume the join column(s) on the partitioned table are indexed? you may find...

I think this is a real tricky question to ask, and I'll doubt you'll get an answer. Web connectivity usually uses disconnected record sets so real time will need continous...