For uniqueness across servers, you can also use a second value, which can often be just a smallint, that identifies the original server that assigned the id. That way,...

You'll want indexes on the lookup guids. And, since they're guids, you'll need to rebuild the indexes fairly frequently. You should also strongly consider reducing the FILLFACTOR on...

If you can use online rebuild, it might be worth cancelling the current index create and running an online version.

Also, you should consider specifying other options -- or not --...

TheGreenShepherd (4/12/2012)

AddressParseStatus is nchar(1) and is used to indicate the value returned by our USPS validation software. It has pretty low cardinality, only 9 possible values. There are roughly 1B...

Actually the SELECT ... INTO is more efficient if the statement can be minimally logged.

I did a search in Books Online for something to verify that:

"

With minimal logging, using the...

No worries.

Mine is more convoluted, I know, but for a large table could potentially perform much better.

As long as you got a solution you could use 🙂

Gillian_Pappas2002 (1/16/2014)

If all of the customer's records have an QS class, those do not have to be updated at all. Only the same customer order records that have at...

No to both. Best is to use a set-based method, possibly like this one:

UPDATE tn

SET order_class...

Here is a sample CROSS APPLY for your situation.

SELECT Part#, CustomerID, ca1.Wk_Num, ca1.Qty

FROM (

SELECT 'A' AS Part#, 1 AS CustomerID, 10 AS Wk1, 20 AS Wk2,...

Yeah, sorry, in too big a hurry, left something out of the code:

SELECT

/* @IdCompany = */ e.IdTCompany,

/* @IdClient = */...

Did you look at the code I wrote??

SELECT

/* @IdCompany = */ e.IdTCompany,

/* @IdClient = */ e.IdClient,

/* @address = */ COALESCE(a1.address, a2.address)

FROM emp e

LEFT...

My guess would be that somehow task schedule is using a batch size of 1 row (or some very small number of rows). See if you can change the...

I'm not sure what you mean about procs and CDC.

CDC uses the SQL log to get changes, so it shouldn't require use of procs, or even know how any change...

Jeff Moden (1/6/2014)

---

ScottPletcher (1/6/2014)

---

Actually, it is a terrible idea to add an identity to this table.

Depending on your specific data, future inserts could be sequential anyway. Even if not,...