Eric M Russell (9/28/2016)

---

ScottPletcher (9/28/2016)

---

You'd still need to keep at least the history from the previous check, because an index/table could be dropped, which would remove it from the system...

You'd still need to keep at least the history from the previous check, because an index/table could be dropped, which would remove it from the system views.

Option (1) should be fine as long as the trigger is efficiently written and there is an index to support the trigger's query. For example, if the table is...

USE HandsOnOne;

SELECT c.CustomerName, a.City, a.State

FROM Customer c

INNER JOIN Address a

ON a.AddressID = c.CustomerAddressID

ORDER BY a.ZipCode ASC, c.CustomerName ASC;

You could populate a table with the test values you want to us, then process from it in a loop or by using GO <#_of_test_runs>, which I used below just...

The irony is it might be more overhead to check for the updates than to just do the log transfers.

In theory you might (should?) be able to use sys.dm_db_index_operational_stats to...

I suggest using a CASE technique to add the desired matches because that method gives you great flexibility on specifically what values to match. The code is somewhat longer,...

Lynn Pettis (9/27/2016)

---

ScottPletcher (9/27/2016)

---

So you want to go from DBA-level SQL to developer-level SQL:

Destroy...

You don't need a global temp table, a regular temp table will do.

Create the table in main stored proc, then ALTER it using dynamic SQL. Since the temp table...

So you want to go from DBA-level SQL to developer-level SQL:

Destroy half your brain...

I can't think of a way right now for that to work using a table variable.

Can you use a temp table instead?

Eric M Russell (9/26/2016)

---

ScottPletcher (9/26/2016)

---

Eric M Russell (9/26/2016)

---

ScottPletcher (9/23/2016)

---

Not necessarily. If the best...

First, cluster the tables for best (overall) performance. In particular, don't assume that every table should be clustered by identity. That's most often simply not the best way...

Eric M Russell (9/26/2016)

---

ScottPletcher (9/23/2016)

---

Not necessarily. If the best clustered indexes are not...

Not necessarily. If the best clustered indexes are not already in place, you...