Jeff Moden (2/14/2016)

---

Perhaps not so fortunate. If...

Check out this article to see if an index on Name may help you get acceptable performance out of LIKE '%phrase%'

http://www.sqlservercentral.com/articles/SQL+LIKE+SEARCH/108015/%5B/url%5D

Short summary:

1. Add an index to your Name column.

CREATE INDEX...

Thanks for posting back. If you think of it would love to hear how things turned out down the line.

Sergiy (2/14/2016)

---

I don't think so.

"Agile thing" is to quickly bake...

What an Agile thing to propose.

Jeff Moden (2/14/2016)

---

If you absolutely insist on deleting the rows, then learn to use EXCEPT between the Address table and the other tables (starting with the largest of the other...

Can you clarify your setup please? Where is the Agent job running and how are you trying to invoke the Package on this remote...

moved here: http://www.sqlservercentral.com/Forums/FindPost1761223.aspx

one final note about FKs, you will need to alter those child-columns as well. i.e. you cannot have a column refer to a parent unless they match data types.

by the way, how long did it take you to exhaust the max value if INT? just wondering what the horizon is for exhausting the negative ID values, i.e. is...

That could also work but will require more downtime. You are somewhat fortunate in this case that the PK is nonclustered.

Some other notes, check for and drop any foreign...

Indianrock (2/14/2016)

---

Well I certainly hope sql server central.com doesn't lose any of this as it will take a while to go through. 🙂 We do have extensive index...

Here is another query form I worked up that should allow you to better guide the QO into filtering data in table-specific-order rather than giving it a flat WHERE-clause and...

Great analysis Hugo. I am learning by watching your thought process on this one. Thanks.

Hugo Kornelis (2/14/2016)

---

Here are my thougts, based on the query, the execution plan you posted, and...

himanshu.sinha (2/13/2016)

---

Thanks for the reply .

Well since the backup size is 200GB , I am not very comfortable using the UNC path but i will give it a...