If you've a copy of 2005 around the tuning advisor makes a much better job than the 2k wizard.

make sure you spread your data across arrays - I assume your import data is local to the server so make sure its not on the same array as your...

It's also largely pointless - just check how many routines are available to decrypt them. You're better removing permissions from syscomments which will deter browsers of your code. There's never...

Hmmm .. should we be messing with the xml files do you think? I did have a quick look but couldn't see anything that seemed to match. I do think...

agreed, although I don't consider myself an old fart - more a grumpy old DBA - but if you're not from the UK the grumpy old bit won't make much...

absolutely, it's an oft overlooked part of database optimisation. Mind you the actual fragmentation is only painful for physical i/o, usually read ahead / scans. Once your data is in...

no sweat - select the file ( open device ) in EM for restore and click the button which says view contents, then check which backups/logs you want to restore.

hmm bad news! I hope you appended the files?

I think .. as I don't do things this way, if you select the file from within EM you should see the...

I'm not sure I udnerstand what you're asking - the tlogs should have datetimes as part of their filename, failing that look at the file create date. If it's in...

oh and yes Jeff I do agree but getting the basics of what needs tuning with the least effort has always seemed a good bet to me and one which...

yup agreed monitoring software has its place, I used diagnostic manager in stress testing ( for example ), sent the output of worst performing ( for each test ) to...

I don't think the ref you mention has anything to do with what you're asking. My guess would be that you can only disable this by unregistering the servers. I...

actually sp_helplogins may do what you require - it didn't fit what I needed.

you can write a script to do this, the biggest problem is getting it to traverse the databases on the server, I usually make use of the sp_msforeachdb undoc (...

I've used Diagnostic manager since it was called SQL Probe back in 1999 or so. I find it provides a good balance of statistical trend analysis, basic alerts and performance...