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

   ...

I believe that you should have asked the site owners first.

Really 'cute' code ... but why ??? just because ???

Give me clarity over cute/compact/tricky code any day !

James, I think that the bullets are actually talking about 2 different positions. A senior production DBA, 100K and a development DBA specializing in integratino and ETL, 70-80k. I'm guessing...

WHy not simplify the process even further. You have a SAN for the backups, why not backup directly to a SAN disk ?

I just have a few brief points:

• There is no such thing as 'A Free Lunch' ...
• Test
• Test
• Test

Here's a previous editorial discussion that applies somewhat:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=263&messageid=212971

Here are anumber of general questions that probably need to be answered:

• Is your cluster dedicated to SQL Server alone or do you have IIS and an application(s) executing on it...

Budgets aside.

SQL Server 101 - A SQL Server is a server dedicated to SQL Server alone.

• SQL Server is SMP aware (can access multiple CPUs) and utilize resources more efficiently if...

Dave, we use Trend on both clients and servers. It really has no really noticable effect on the time needed. The only hiccup I have noticed is that when computer...

I do not know a great deal about cross-database ownership chaining but you should be able to set things up so one user id can perform the tasks you need...

First things first. What is your database 'recovery mode' - simple, full or bulk-logged ? Answering this question will partially determine the options and best course of action to take. Next...

Here's the ordering link: http://www.microsoft.com/sql/prodinfo/previousversions/rs/retailfulfillment.mspx

Once you get your media, a couple more useful links:

http://www.microsoft.com/sql/prodinfo/previousversions/default.mspx

http://www.microsoft.com/sql/prodinfo/previousversions/rs/downloads.mspx

If you cannot wait to start, here's the link for the 120 day trial:

By the way ... if anyone has a spare "+5 Wand of Network Admin Brainwashing" that they would like to part with I'd be glad to take it off of...

I have also seen issues with 3rd party/vendor software having connectivity issues with named instances. If the application can handle it, then there is really no difference between a default...

I noticed this issue a couple of times in the past. It drove me crazy. Have you changed the passwords to the service accounts running SQL Server and/or the SQL...