If you're using a 'work' email account like I am maybe you can have a quick chat with the email/exchange admin. We've implemented a number of new and diffrent technologies...

Sometimes SPs just won't do - especially if there is a lot of DDL involved. For these 'special' cases I'd use CmdExec and OSQL instead !

Only if the solution uses sp_MSforeachtable ... LOL !

'Recovery Mode' anybody ??? Ultimately this affects how an individual database reacts to the command listed in the beginning of the post. e.g. 'Simple Recovery' does not require a full...

I'd opt to make the owner 'sa' - this login always exists on every SQL Server. Whereas 'aaron' or another arbitrary name might not, then causing you potentially many issues....

Check out this link: http://www.connectionstrings.com/

It has a Paradox section and 'stuff' that relates to Access and .NET. So I'd guess you could convert that information into an Openquery. Unfortunately...

Tell your AD guy to hit the books on networking. This has absolutely nothing to do with AD at all it's in DNS management. However you must be a Domain...

Round III

    Profiler - you're already there

    Query Hints

It all boils down to choice. The choice to state (and believe in) the words Yes or No.

• Am I a realist - Yes.
• Do I care that it is out...

I'd opt for using a DNS alias - it's the quickest and easiest way. Besides, this then has absolutely no impact on the cluster or the physical nodes.

Trick answer:

4) Other --> alter database [database_name] set AUTO_SHRINK on

This shrinks both the data and log portions of the database whenever the SQL Server engine feels it has the time....

I'm curious as to what Bill uses for a screen saver ... maybe it's:

http://www.sysinternals.com/Utilities/BlueScreen.html

I would not remove the 'WITH RECOMPILE' if this is a batch type proc. The 'WITH RECOMPILE' option on a SP allows it to make use of the updated statistics...

Here's my 'short list' for tuning:

Round I

    DBCC UPDATEUSAGE

    UPDATE STATISTICS (with FULL scan) for all tables

    exec sp_recompile for all tables

    exec sp_refreshview for all views

Round II

    DBCC DBREINDEX

   ...

Have you looked into NET STOP ???