Sounds good. Thank you sir!!

Elliott Whitlow (2/21/2012)

---

At a high level I believe it will work. I don't believe the nodes have to be evicted from the cluster for it to work just that...

Scott

I would say that your article is spot on speaking from experience. My old environment was built from the ground up to be virtual and...

I have one 1.2 TB database currently on line and about 6 more to follow within the next 1 to 2 years. It is a scary experience learning how to...

I understand. Thanks for taking a look at this with me and have an awesome day!!

Yes - The problem is that the view was built into the product years ago and is now used by all customers for data analysis. It seems to only throw...

Thanks for looking G - Is there anyway that you can think of to force SQL to not use that field other than rewriting the view?

I thought it was the view also but could not find the offending join. The tables columns used for the join are all of the same type and have indexes....

Here is the execution plan.

Hi GSquared

The query is extremely slow....4 hours. Let me see if I can get the exec plan uploaded.

Just to add my 2 cents. My entire environment is virtuals with VSphere. I am lucky that the environment was built from the ground up as a virtual environment and...

I have had to do this similar move recently. Below is my code and it borrows from a multitude of different gurus. After you run the script initially to get...

Thank you to both CoolWebs and CirquedeSQLeil for your patience and for pointing me in the correct direction to fix this issue. You Rock!!

I see your point and was aware of the possible issues of nolock or read uncommitted. Fortunately, we do not always use it and when we do it is for...

Thanks a lot CoolWebs for the info and your patience. Your explanation sheds light on the issue I am seeing.

CirquedeSQLeil - A couple of things. First, the view definition...