Gail - I didn't disagree with you, just clarified - the conversion is only one way which causes a problem in 2000  whereas in 2005 it doesn't stop the seek...

glad you posted this under "not about sql"

thought everyone had heard of mysql - opensource and free - loads of books in bookstores for it, pop along to your...

std is limited to 4gb unless you go 64bit R2 which supports 32gb ram

is that 10hrs for a table ?  Then you need faster disks, more spindles, no raid 5 , and/or data partitioning.

In tests I found indexdefrag to be pretty much...

the main disk counters which are of interest are the io completion time and the number of disk io. You wouldn't want to see an io taking more than 10ms...

charles - and that's what's wrong with it all - this is reverse discrimination of the very worst type and if it were the other way around would no doubt...

you examine the contents of the disk drive to see what's on it. explorer view will give the overall stats, right click properties of folders to see which folder contains...

technically you're sort of right about the cpu's except, a dual core adds about 0.6 for the second core, or a dual core is about 1.6-1.8 of two actual single...

we had a long discussion about cursors vs loops, a while loop is still a cursor and I doubt the impact within a single trigger would be much different.

My view...

I do feel for you and it's difficult trying to visualise what I'd be doing in your situation - trouble is so much tuning is almost a black art -...

I hate to disagree, how unlike me! , but Gail's statement needs some clarification .. ( I should add that I'm only sort of up on this as I'm tuning...

agreed. but you could also script the database from EM in 2000 and run the script against 2005 or dts the entire database , although not such a good idea...

I think you've been missled.

I thought about it and how one might prove this or otherwise, sql server will always read the row ( page ) and anything oft used...

This is all covered within Books On Line.  You'd probably resolve your problem quicker actually using the provided documentation then posting to the forum where it might be a while...

I never fail to be surprised by some of the posts.