LOL! Every SQL Server related job I've ever had, at some point during the first week, I get handed some pile of nonsense like this and told it's now one...

Or when rolling off to history hourly:

where datediff( hour, PrintDate, getdate() ) > 120;

Could it all be as simple this: a single delete operation that leverages an output clause to insert deleted rows into a history table? If this were to be...

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