Andrew L. Smith-213145 (8/2/2011)

---

All:

I have found the culpret! If you specify to verify the backup, this is what is causing the job/plan to hang. I removed it and all the...

I'd only be left with close everything and hit refresh after reopening.

I had similar issues when wanting to change the server the connection was pointing to.

Where do we go fetch that info? Any dmvs?

A view is just a saved sql query. The results are not meterialized untill you call the view. If you use an indexed view then the results are...

cengland0 (8/2/2011)

---

Ninja's_RGR'us (8/2/2011)

---

Yup. But you're smart enough so that I don't have to go back and edit it.

That's what...

Fraggle-805517 (8/2/2011)

---

Roy Ernest (8/2/2011)

---

The only thing that comes to mind is Hyperthreading being enabled. I have seen cases where the server hangs due to memory pressure and starts throwing the...

Stepping out... out of my league here.

Good luck with this.

As a final not, a solution you feel competent in providing is always a good start...

See my previous post.

Unless you can change the left to inner join then this is not a viable solution.

Is the default DB set to auto_close or auto_shrink?

left outer join address a with(nolock) on a.parent02aid = CONVERT(VARCHAR(50), m.acctid )

I still think refactoring is the solution if it matters.

Looks like this one might be the problem to me... on m.acctid = c.lutcode

Do you have dbs on auto-close. I just saw gail saying this is what happens in that particular case.

How did the server go down? Anything else in the...

dajonx (4/4/2011)

---

Good morning,

I have encountered an error when clicking on the "System CPU Utilization" graph. The error says:

A data source instance has not been supplied for the data source...

I was thinking more about a import package that merges the data on SQL Server.

Then maybe redownload everything to access if need be.

Why so many char instead of varchar?

Which join is failing?

P.S. Don't use nolock unless you want incorrect results. http://sqlblog.com/blogs/andrew_kelly/archive/2009/04/10/how-dirty-are-your-reads.aspx