Nice question. I learned a couple things.

I ran it. It returned 'this'.

Thanks to all who answered. It is truly appreciated.

Chris

GilaMonster (7/1/2011)

---

In this particular case there are very few advantages to having that exact index, seeing as the table is so small. Swapping the columns around (col4, col1) however could...

GilaMonster (7/1/2011)

---

No it's not. SQL includes the clustering key in all nonclustered indexes anyway whether...

Syed Jahanzaib Bin hassan (7/1/2011)

---

Dont use Clustered index column in the NonClustered index this is overhead and leaf level of this nonclustered index will be same as your index when...

We use the custom counter feature in Idera DM, too. It can really add to the functionality for those things that may be specific to your site.

As far as I can tell, the web edition supports the SQL Agent scheduler. If so, you can schedule the backup yourself using scripts rather than using the wizard.

Check 'Integration Services' at http://msdn.microsoft.com/en-us/library/cc645993.aspx

The last column shows that there were not many threads waiting on a CPU the the moment you ran the query. I was wondering if there were a lot of...

1) What does the following script show when the server is running slowly? The runnable task count column shows the number of tasks for each processor waiting on CPU.

SELECT scheduler_id,...

Or backup to the mapped drive if you do not need the original copy.

One cause of the error is trying to restore to a earlier SQL Server version - for example, trying to restore a 2008 backup to a 2005 server. This is...

Are you restoring to the same server as the backup was taken?

Thanks Gail. We have tried to get the specific errors from our vendor. Maybe they will come through some time soon. I'm just glad I wasn't missing something too obvious.

Chris