ChrisM@Work (2/16/2016)

---

Two or three of your candidates this time around are so ridiculous that the entire rest of the reasonably civilised world is quaking with laughter. They won't find it...

Exactly what steps did you take, in what order, when providing .bak file to SSMS to restore it?

What were the results you got from each step?

Grant Fritchey (2/15/2016)

---

Hugo Kornelis (2/15/2016)

---

jasona.work (2/15/2016)

---

So, a question for everyone:

How do you feel if someone comes back and tells you that they tested a solution you provided before they told...

Please post:

- The relevant table(s) - in the form of a CREATE TABLE statement that I can copy/paste, not as an image; and do include all constraints and indexes, please

-...

jasona.work (2/15/2016)

---

So, a question for everyone:

How do you feel if someone comes back and tells you that they tested a solution you provided before they told their bosses it was...

Please help us help you. Post the following to make it easier for us:

1. CREATE TABLE statements for fake tables to mimic the results of your two views. (They work,...

The point you are...

First: Choose if SQL Server 2012 is the best choice. SQL Server 2014 has been available for almost 2 years now, and SQL Server 2016 should hit the shelves later...

Exactly what steps did you take, in what order, when you tried to restore the .bak file you have?

What were the results you got from each step?

... plus the expected results

My first thought, right off the bat: is SQL Server even the right tool for this?

Your problem does not look like a good fit for a relational database. Perhaps you...

Thanks for posting the new plans. 20K in 10 minutes is defintely an improvement and I can imagine that you are happy with this. But I think this can go...

That delete logic looks pretty inefficient. I think you can use this as the delete statement:

-- Delete first 1,000 addresses

DELETE FROM collateralmanager.DBO.ADDRESS

WHERE ADDRESS_ID IN

(SELECT TOP(1000) ADDRESS_ID

...

Indianrock (2/14/2016)

---

As far as indexes on the temp table, the temp table is created with an integer ID identity column as primary key.

CREATE TABLE #tempdata

...

Indianrock (2/14/2016)

---

Thanks Hugo, I will thoroughly review your post.

I'll experiment with the number of rows gathered into the temp table up front -- this is only done once per day...