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...

CREATE TABLE #temp1_dup_emails (email varchar(20) PRIMARY KEY);

Insert into #temp1_dup_emails

SELECT CASE WHEN which_email = 1 THEN email1 ELSE email2 END AS email

FROM #temp1

CROSS JOIN (

VALUES(1),(2)

) AS which_email(which_email)

GROUP...

Personally I wouldn't rely on sys.partitions to gauge whether a table is completely empty or not. Maybe just me. Just out of curiosity, what if a table load...