The DTA is a tool like any other - you get to understand what a tool does by using it, if it suggests xx index will aid performance by 63%...

I'd suggest you cycle your error log every day to avoid getting a really large log.

check your query plans - view estimated plans, not actual. I'd give best guess your proc is table scanning not using an index seek - index to suit.

( could also...

it was always claimed that the binary setting produced the performance gain - not quite the same as CS I think - not sure as I normally create CI...

actually cache is another myth put forward by the vendors - in the early days of tcp benchmarks, back in sql 6.5 and sql 7 days it used to be...

And here lies the problem - some vendors tell customers that san's outperform DAS, disk for disk this is untrue a disk still only has x i/o per sec and...

it should resize instantly, it's a tiny increment. Don't do it in small chunks you'll only increase ntfs fragmentation. I suggest you check for that prior to expanding and...

if you enable awe it disables dynamic memory allocation so the only setting which is important is the max memory settings ( 32 bit versions ) There's a KB...

if it's anything like Navision you have my sympathies. Hopefully you should be able to restrict sysadmin and dbowner rights - that at least may help. You can still enable...

without wishing to sound "nasty" there is an inherent danger in downloading and using scripts you don't understand - especially if you're using them against production systems - so if...

I have a series of posts about how indexes work - this one ( I had to post in three parts so if you want the original doc drop me...

welcome to the wonderful world of mystery storage!! Ever since the first SAN arrived I've found performance problems with SQL Server. I got SNIA certified so that I could ask...

I'd really advise you to NOT perform an update in place. My experiece has shown using new installs and migrating is a far far better option.

If you've taken a server...

You'd just do so much better going on a training course rather than trying to change a database structure that you might not understand, especially if it's a production database....

I assume you mean sp_who2 ? Most 2000 code works on sql 2005 as pretty much all the old system tables are supported with views - this may not...