all sql servers are different. I use benchmarks but set this on a per server basis. You could buy the sql server 2000 performance tuning ref isbn 0-7356-1270-6, this has lots...

hmm .. my post didn't publish .. I posted to say thanks and to say that I just learned something I didn't know - cheers.

just in case any of my posts are taken as stating that I think women don't have the mind for IT - that's not what I intended - what i...

I figure ultimately that in general terms women don't find IT appealing, now I don't know if that's to do with mainly males working in IT or the men are...

It only looks for user objects if you don't qualify the sql, which is best practice, therefore user fred executing  select * from mytable will, as you say, look for...

certainly backups are resource intensive, as you'd wish them to be - I don't have the test lab setup to run a series of tests like this currently but when...

as I'm somewhat in the "older" category I suppose I don't notice some of what goes on, and as I'm independent ( consultant/contractor ) the politics at work rarely touch...

depends what you mean by increase - if the queue goes above 5 then I'd be worried. I don't have any similar setup that i could test to see if...

As is often the case i've not had any problems restoring databases to 2005, I've taken a collection of production and test databases to 2005  including a replicated database, all...

That's cool and thanks for posting - so often we never get to know what a problem was or if it had been resolved, appreciated.

I never write the profiler data I'm collecting to the sevrer I'm collecting from ( well generally not ) sounds as if you are slowing your disks by the profiler...

try export to text file and import. Never did like the cut and paste!!

to be honest detach and attach is about the easiest method, although restoring backups work just as well.

The database stays in 2000 ( 8 ) mode , you need...

I don't want to be more rude than normal, but how about Books On Line?  You're looking for Management Studio / Visual Studio which should be in your program files. Enterprise...

The most likely cause is poor hardware, certainly disk queues mean poor disk subsystem. This really isn't a quetion that can be resolved just like that.

There's lots of info on...