Definitely set the max memory.

How big is your database? How many people are accessing it at the same time?

Yeah, all those table scans are not doing you any favors whatsoever.

The query plan is timing out too, which means it's unstable. Run it on another day when there's a...

No inspiration for one this time.

Perry Whittle (4/1/2015)

---

This is the last thing you should do and you'd be well advised...

jellybean (4/1/2015)

---

Thanks for the post Grant. Nice. Here is my updated list therefore:

0. On the *separate* target box install Sql Server 2014

1. Upgrade to Sql Server 2005 SP4 if not...

Arjun SreeVastsva (4/1/2015)

---

Hi,

I have tried to shirnk the database also below error I am getting

The transaction log for database 'New' is full due to 'AVAILABILITY_REPLICA'. (Microsoft SQL Server, Error:...

To begin to get an understanding of what is needed to help out, I'd like to suggest getting a copy of the book "Troubleshooting for the Accidental DBA." It's free...

Wow. "Here's a screen shot that says the same thing I already typed. That should clear up everything."

Frightening.

Perry Whittle (4/1/2015)

---

Grant Fritchey (3/30/2015)

---

Also, the log backups can, roughly, be taken anywhere and then combined later.[\quote]

Although, ideally, you'd store them all in a central location so they're available immediately...

A common table expression is just a derived table (except when we're talking about recursion). So you can just treat it as another table in the query:

WITH myCTE AS

(SELECT *...

Could you capture the execution plan? There's just too much to walk through there. If we can see what the optimizer is doing, it'll be easier.

Are all the properties on each of the operators in the plan exactly the same?

On a guess, I'd be inclined to suggest differences in the ANSI settings possibly causing differences...

I'm with Kevin. And the way around this is to try out the third party software on your own. Don't look to them for support. Test it and see if...

I'd suggest looking at the statistics in more detail, especially on the tables that are the biggest or that are called the most frequently. Get a sense of how the...

Well, Prompt does it for me...