I've found that in general terms the w2k3 defrag tool is sufficient. Used this on SAN with no problems. It also doesn't cost anything which is always good!

It seems fine, and largely irrelevent to me. I don't see any variation in the posts in the forum and to be honest does it really matter who owns the...

you obviously haven't met some of the developers I have!  heh heh

Phil - loved the solution - that's what i wanted someone to come up with!

just remember that you too will be "old" one day, although in the case of some mangers this may come from luck rahter than anything else < grin >

I'm at a bit of a loss to understand why it should take "under an hour" to write a peice of code that can be pasted from BOL ??

It still...

generally I belive the dual core amd's outperform intel up to 4 sockets, after that it's a little more blurred. Some intel dual core's also support HT so you get...

That's an interesting view but you can't usually optimise an update or insert to use less tran log, I agree you can optimise the queries but an insert is an insert....

I'm not sure about automating this, would probably be fairly ugly sql. I usually divide the number of rows in the table by the distinct values in a row to...

actually I didn't explain myself very clearly I now see. I should have said if you then update selected rows increasing the varchar from 20 to 1000 you'll get fragmentation...

one has to an instance.

If you script the index any fill factor will be included in the script. You can also examine index properties from within EM to see this.

Setting fill factors is an...

this is what all producers of poorly performing code ask, sorry! Tune your stored procedure - you can't assign cpu, thank goodness.

Steve - yeah agreed it's not too bad until you have several gb of logs to go through!! also assumes you know what you're looking for.

new it would get into a saga of worst managers I have known .. As a manager it can be very difficult to get rid of poor staff ( who...