I can perhaps assist here with a practical example. My prod systems are all san attached with high performance raid 10 raid sets, but my DR servers have to exist...

I always use profiler as the overall exection time of a complex proc is meaningless without the breakdown for each statement.

It's actually a much better route to follow - as...

online does not use double memory - where on earth did that come from ! sigh! If you pad indexes you'll have a low scan density - actual fragmentation is...

what are you looking to find? Do you have a problem?

I have to admit I have no idea as to your problem - even with the output - what i would say is that there are differences between versions of...

the obvious danger of adding all those certifications after your signature is you put yourself up for a fall.. I can only assume you've never used a log shipped standby...

funny enough I just posted about this, sort of, on my blog. I never use procs for this type of thing - far too restrictive and not flexible in a...

I'm not sure if we're very clear here - set statistics io on show io statistics not cpu. using this in SSMS is a good quick way to...

user databases will usually always move forward up the versions without issues. System databases will not, so if you're trying to restore msdb then you'll likely have errors.

could you clarify...

there isn't directly, but what you can do is create another account on prod with the rights required - this will migrate to log shipping ( assuming you're moving logins...

sql 2000 has been out of support for some time, I'd be surprised if there were anything to deal with that sort of backward compatibility. You've already answered your own...

sorry but there's quite a bit of out of date and basically incorrect information in the answers before. I've been working with sql server on storage area networks since SQL...

oops! sorry should have said "without" alternative source of power.

In all sql servers the "disks" are a single point of failure, regardless of clustering. Clustering is hardware failover for the server ( e.g. your box with cpu, memory and...

without auditing I do not belive there is any one place you can pull this information from. The trouble with the built in reports is that they are not available...