All of the _WA_% indexes are system generated and shouldn't be a problem. I would run the following to make sure there are no additional problems with the database....

We have two dogs, the daughter has a cat that thinks its a dog and the sister...

Instead of looking at the history of the job - view the history of the maintenance plan (Open the Maintenance Plan folder, right-click on the maintenance plan and select View...

Here is a thought - create a report in Reporting Services. Schedule the report to be run and delivered every day by email in HTML format.

You can either have...

You know, I keep hearing about the number of post on The Thread. It is an impressive and truly astounding number.

But, has anybody checked out the number of views?...

Ken - yep, it is one of the 'it depends' type of things. It really should be something that is tested and accounted for on each system you support.

There...

A couple of options:

1) Dynamic SQL - build a sql string and execute the string.

DECLARE @sqlCommand varchar(max);

Set @sqlCommand = '';

SELECT @sqlCommand = @sqlCommand + ' SELECT {columns} FROM ' +...

Well - this is one of those 'it depends' type of questions. There is no problem in SQL Server 2005 with multiple tools performing full backups.

The problems occur when...

It probably makes sense to stagger the start times of each type of backup. At least, between the differentials and the transaction logs. Starting the transactions logs on...

Nicholas Cain (5/28/2009)

---

If your server has 19GB of memory you should set the max server memory to 17GB

SQL could just be choking down on the OS causing the lock ups...

Direct from books online's help about SQLCMD:

[ -q "cmdline query" ] [ -Q "cmdline query" and exit ]

Which one do you think you should use?

Lookup the topic SET IMPLICIT_TRANSACTIONS in Books Online. You can set this for the connections, or set it for all new connections in SSMS.

Ken Simmons (5/27/2009)

---

If you don't need to update your statistics with full scan - then you should use the procedure sp_updatestats which will only select statistics that need to be...

That is the whole purpose of SSIS - I would recommend using BOL and http://www.sqlis.com to get you started.

Lynn Pettis (5/27/2009)

---

There is nothing inherently wrong with this post, but I have to wonder off to my tent in the desert. What do we do as DBA's that...