My understanding is that you have a Names table, and then you have an Address table. Actually you have multiple Names tables for some reason, but we'll put that aside....

It seems that most public software engineering discussions revolve around the paradigm of either eCommerce shopping carts or social media. But that's just not applicable to most database applications. They...

cyanes (4/1/2015)

---

I have a basic load proc (loading a staging area.) that truncates a target table just before inserting fresh data in said table, all wrapped in a distributed transaction....

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