forget the fill factor, you'll not be helping yourself at all. There is a serious missunderstanding in how fill factors can be used or abused. A series of sequential inserts...

The SQLCAT team have also joined in the debate upon the use of NOLOCK

http://blogs.msdn.com/sqlcat/archive/2007/02/01/previously-committed-rows-might-be-missed-if-nolock-hint-is-used.aspx

Makes interesting reading and adds some more information.

My view of the "Oracle" locking is that it...

You need to understand transactions and isolation levels and how this all works, then you would be able to make moves to improve performance. I suspect you have blocking processes.

yeah raid 0 is fine except if you have transactions running which use tempdb, then you could suffer an inconsistent transaction, you have to decide the risk vs cost vs...

I had some similar problems ( without virtual servers or pc's ) there's some issues in ms kb about xp. Other than that our issues related to nested transactions and...

It's a good way to slow your database down.

• Read Books On Line
• Buy Inside SQL Server Book
• Attend appropriate training course

This question is far too generalised. I'm sure there's a wealth of written articles on the site on this subject...

you'll not find any advantage to placing tempdb locally, especially on a raid 1.

I find the biggest mistake made with splitting out tempdb is to not match the spindle count...

I have to say I've greatly enjoyed a  number of the discussions of late .. the subject matter may be diverse but it's certainly been exercising the old brain!! This...

Tony Rogerson did some work on this

http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/08/24/958.aspx

There are other ways to boost tempdb performance, multiple files for instance. I find many people don't allocate enough spindles to tempdb when...

most queries don't tend to generally get split into parallel plans, this is generally good as you'd not really want all your queries to be that costly. There's some ms...

there are usually ( sometimes very large ) differences in io counts between qa and profiler, I only ever use times in profiler as I'm usually looking at running systems....

my experience with vmware has generally shown performance degredation. I personally don't believe virtual drives are good for databases, however, we've all been using virtual drives for years ( it...

There always seem to be confusion over this subject, for as long back as I can remember and before forums and so forth became so popular. There's also still confusion...

chris - I'm not having a go here but -- I sometimes tire a little of posts that attempt to "throw" large numbers about - assuming your million page hits...