the fastest way to return data is to make sure the table is in cache, there is no contention, there are indexes which optimise data retreival and any updates. If...

could you be a bit more specific please? like which pool and probably why?

there's a couple of rdl's you can download which will show some info

http://sqlblogcasts.com/blogs/grumpyolddba/archive/2008/02/12/custom-reports-for-the-dba-without-ssrs.aspx

most commands still work in 2005 but many do not in 2008. Putting a 80% fill factor will make your database about 25% bigger.

this proc will do a full...

Because I wish to be diplomatic and to be honest slagging off a company is really bad practice and doesn't really add anything constructive - I don't want to mention...

yeah but you miss Jeff's point that, and I've seen this too, developers end up casting every character column to upper or lower which does screw things up big time.

Funnily...

I suspect that most people who claim the performance gain for binary have never actually read it up. The gain is there but only for selected searches/sorts and in most...

The main problem with SAN performance is that the monitoring tools are very expensive, most clients don't buy them so you are on a hiding to nothing to start with!...

fn_virtualfilestats is fine with sql 2005 , think you're being too picky!

I sense a vast lack of knowledge in dealing with the original post - quad core procs do support...

Hmmm .. my desktop has more RAM than that!! I'd suggest you might go to 4GB ram on your server, out of the box that'd give sql...

you need to run / collect perfmon data to manage this - or buy a tool sauch as Idera SQL Diagnostic Manager - This is all part of trending and...

I seem to recollect we have had this same discussion so many times over the last few years. As a certified ( http://www.snia.org ) person I'd suggest you challenge the...

I've remarked a number of times that whilst the amount of information available on the various ms blogs is fantastic it doesn't always link up team to team, sometimes the...

I'm thinking about a post/page about x32 memory - I thought that this subject was old hat these days but obviously not! I also want to test x32 on...

you should not use the raw data in the dmv's for index analysis, always port the data to a table at regular intervals and analyse from there. I had some...

It seems to me there's still so much lack of understanding how memory works with SQL Server. Forget x64 and consider x32. You only have three options ( + one...