Robert

Great article, and you are obviously very helpful.

I understand the concept of teamwork, and the comment about 'you never know when...' however, in my curmudgeonly...

The MAP scan easily finds all versions of SQL and all components installed if you have the elevated permissions required to see all machines on your domain. SQL Browser...

Just read a sales pitch from Condusiv Technology, who now owns Diskeeper. Lots of mention of performance degradation due to fragmentation on SAN storage.

http://www.condusiv.com/solutions/storage-solutions/san-nas/

and no, I do...

We set the 'Optimize for Ad-hoc Queries' setting. I should have mentioned that in my initial statement.

Almost all of our SQL servers supports third-party applications and...

SQL Secure does a fine job of determining inherited permissions.

Jeff Bennett

Saint Louis

SQL Secure does a fine job of determining inherited permissions.

Jeff Bennett

Saint Louis

Thanks. It is not so much Microsoft that I am worried about. I am worried that in the hands of well-meaning but ill-equipped developers this could...

I recommend that you consider only running using the following parameters instead of 'ALL'.

DBCC FREESYSTEMCACHE('SQL Plans')

DBCC FREESYSTEMCACHE('TokenAndPermUserStore')

SQL Plans will clear your ad-hoc bloat, and unless your server is configured for...

Craig,

NETApp is very good for what it was designed to do, which is, taking very fast snapshot backups of entire drives. This is an awesome tool from a storage tech's...

Craig,

We have started adopting NETApp Snap Manager for SQL Server, and it looks like the road will be long and steep.

I have not found any recommendations for NETApp...

crickets. It is so quiet I can hear crickets.

The existing team of DBA's I was hired to assist were more comfortable with gzip because it had been used in their previous lives as Unix gnomes.

Brilliant!!! Outside-the-box thinking that turns conventional processes on their head.

Thank you, Oleg.

Jeff Bennett

SQL DBA

Saint Louis, MO

Manish,

FORFILES is an OS function that is probably deprecated in Windows 2008. Fortunately, if you get the latest version of gzip, you can simply use the -r switch...

Yeah, you had me going. I was feeling bad for you, man. I thought I had worked with that TechDBA.

Forget all that moaning.

Thanks for the...