You can prevent duplication of service codes by leveraging an INSTEAD OF INSERT, UPDATE trigger where each service column is conditionally populated depending on whether a preceeding service column has...

If the procedure uses BEGIN TRY / BEGIN CATCH error handling, then confirm what it's doing with trapped errors. Consider commenting out the error handling blocks and just let...

Really, your disposable audit records that you purge after five days must have referential integrity and must be totally consistent? Let's consider that over engineering on the part of the...

Eric JOATMON (4/1/2015)

---

Steve, when I first read your post, in which you said "we suffer from the chef problem in techology", I thought you were going to make an anology...

Maddave (3/30/2015)

---

...

I've been asked to come up with a better solution to delete the data. I can delete it in batches, which would solve the tlog growth, but it wouldn't...

sqlfriends (3/31/2015)

---

Thank you, yes the session is blocked by other sessions doing the same query with different parameters

The query is:

(@p0 datetime,@p1 datetime,@p2 bigint,@p3 datetime,@p4 datetime,@p5...

Post the text for the actual UPDATE statement and also for the statement that is blocking.

Am I...

Once a year I watch 'The Sound of Music' with the family. This is one movie that could never be properly redone.

Michael Valentine Jones (3/31/2015)

---

It amazes me when they make a movie of an old TV series that I thought was terrible even when I was a kid.

Lost in Space

The Brady...

What I was referring to is something like the following. Here we have a...

To pad a resultset with missing rows required to form a complete set, you can...

Most ETL jobs from source to target want to perform both inserts for new rows and updates for existing rows having the same primary key. However, if you only need...

Steve Jones - SSC Editor (3/27/2015)

---

Eric JOATMON (3/27/2015)

---

Steve,

You mention "extra columns in a result set" as being a downside to deploying database changes prior to application code changes. That...

You can use the following to identify what procedures or queries are using "SELECT *".

SELECT DISTINCT objtype, db_name(dbid)dbname

, object_name(objectid,dbid)objname, usecounts, [text]

FROM sys.dm_exec_cached_plans P

CROSS APPLY sys.dm_exec_sql_text (plan_handle)

WHERE [text]...

When clustering on a composite natural key, perhaps something like OrderDate + StoreID + SKU, then place the most sequential column in the left most position. Not only does this...