When would the trigger fire? After all the inserts/updates are done?

Are those values from other columns? Values from input parameters for a stored procedure? Values from a direct insert by the application? Something else?

Here's what I've used for that kind of thing:

USE ProofOfConcept ;

GO

-- Set up table

CREATE TABLE #T (Col1 CHAR(1)) ;

INSERT INTO #T

(Col1)

VALUES...

I'm a trained minister. Does that count as "cross training?" (drum-roll please!)

As far as DBAing goes, I'm not sure there's a solid line between "training" and "cross-training" without going...

I'm assuming from the syntax that it's part of a Merge command. If so, it should work. You might need to remove the object-name ("t.") from the column...

"Up" is the direction radially outward from the local, subjectively predominant gravitational influence.

At least, that's what I say when someone asks, "What's up?"

Lynn Pettis (4/5/2012)

---

If it...

TravisDBA (4/5/2012)

---

Any time you want to see the warts & all presentation, come watch mine. I don't hold back. We have a ton of advantages over Visual Studio. They have...

GilaMonster (4/5/2012)

---

GSquared (4/5/2012)

---

Stefan Krzywicki (4/5/2012)

---

Brandie Tarvin (4/5/2012)

---

Wow. Reading that thread and comparing it to the several 17+ hour shifts I've got through the past couple of days...

I think I'll keep...

Stefan Krzywicki (4/5/2012)

---

GSquared (4/5/2012)

---

Stefan Krzywicki (4/5/2012)

---

Brandie Tarvin (4/5/2012)

---

Wow. Reading that thread and comparing it to the several 17+ hour shifts I've got through the past couple of days...

I think I'll...

Keep in mind that there can be slight differences, especially at the highest precision point, simply due to CPU sequentiality constraints.

MaxDOP 1 might change how that behaves, but also might...

Grant Fritchey (4/5/2012)

---

Look at it as a complement. To many people, we're the SQL Server documentation....

Fragmentation in the database world usually refers to index fragmentation. It happens (usually) because of inserts/updates/deletes of the data that's being indexed. It can slow down use of...

Stefan Krzywicki (4/5/2012)

---

Brandie Tarvin (4/5/2012)

---

Wow. Reading that thread and comparing it to the several 17+ hour shifts I've got through the past couple of days...

I think I'll keep my current...

I always keep a DDL store of some sort or another, to be able to deploy a copy of a database. I also keep DML statements for creating lookup...