Need to see the...

Bruce-12445 (11/8/2010)

---

I didn't try the temp table but that works, thanks for that.

I'll also see if the vendor will allow adding indexes.

If I use a view I obviously can't...

Then you're relatively screwed.

You can try dumping it all to a temp table and working it...

Test system, I hope? If so, try this:

CREATE INDEX idx_testing_orderby_AMS_CATEGORY ON AMS_Category ( Category_Name, Category_ID)

if that alone doesn't work, alter your JOIN to INNER JOIN dbo.AMS_CATEGORY c WITH (INDEX(...

A couple of ideas.

1) Look to see if its waiting on locks. Specifically when it runs long, see if it's waiting for an exclusive table lock. It might...

I've always been a fan long term products, and have yet to truly understand the need to re-invent the wheel every 3 to 5 years. Some good has come...

Find the drive your main backups are going to on the network, then contact your sysadmins and ask them to see if there's maintenance on those drives at that time.

The part of that which matters:

Error: 2010-11-09 08:00:02.97 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "BACKUP DATABASE [New_kvr] TO DISK = N'E:\Database..." failed...

WayneS (11/8/2010)

---

The trick here is that you're separating the where clause, and the datediff functions. All that you will get out of the CTE are the records that pass the...

NOW you tell me... 😛

Diff backup should not break log chain. Have you checked the server logs to determine if something else is doing log backups, or if something is altering the recovery...

malik_nagel (11/8/2010)

---

Thanks again - but again, we can't use the hosted SQL Server (A) at all. That means no BCP, SSIS, Robocopy, or anything else. All code must...

CirquedeSQLeil (11/8/2010)

---

Craig Farrell (11/8/2010)

---

Minor derail. I wrote up an article in the editor here that I'm working on. I'm not sure how to give a link or visibility...

cte's are guaranteed to be pre-processed by the optimizer before the...

Minor derail. I wrote up an article in the editor here that I'm working on. I'm not sure how to give a link or visibility to another for...