I thought that was bad...to just drop them. Plus I thought there was a new preferred...

Thanks Bob

update - it is starting to consume some space.

does it write it out as it goes? or does it wait until it's completely done to write out the indexes?

Thank you so much Grant. You are always helpful and informative. Looking into your suggestions now.

Capture the wait statistics when the procedure is run in order to understand what is...

looking into this..you could be right Bob..thanks.

Awesome. Thank you very much Lynn.

Yeah..thanks.

High Avail is pretty cool, but it's kinda a pain also.

It's nice once it's setup but setup can be a little painful. I got stuck with a 'restoring' state on...

Thanks everyone!

We are purchasing the dev version.

Grant Fritchey (4/4/2015)

---

If the partitioning is working for your in production and you're actually using it, removing it doesn't make a lot of sense. If this other server is not...

I found a way:

http://www.sqlhammer.com/blog/connecting-to-an-availability-group-listener-with-sql-server-management-studio/

thanks Gianluca

but I close the spid and another lock pops right up

what can I try next?

LCK_M_IX

Thanks Grant.

Long story, but it's financial data and I'm new there so can't complain..yet.

Kinda figured those were my only options. Shame I can't use my high avail...without read only.

Think I...

Got it.

Mucho thanks Phil.

Thanks Alan. Much appreciated.