You have two indicators for the same thing: the flag, and whether the date...

Eric M Russell (10/23/2015)

---

I've found a Date type is more useful for indicating active / inactive status. I want to know when, not just if, a row changed to inactive...

Denormalisation alert 🙂

Henk Schreij (10/23/2015)

---

Not exactly an answer to the question, but I use a field named State, Status, or Condition.

VARCHAR(1), Default '' (an empty string).

I fill this field with a Char...

The negative form leads to difficulties with double negatives (if isInactive = 0). The positive form is much clearer.

Orlando Colamatteo (9/18/2015)

---

That would take some additional engineering to avoid creating a bottleneck and also to release unused...

That would be ideal.

As you say, OPENROWSET is very inefficient. A CLR is efficient as long as the connection object is cached.

allarmi (1/21/2014)

---

hello, thank you for your work.

i'm still looking for a transaction independent way of logging the activity going in an arbitrary number of procedures regardless of their nesting level...

I can see the benefit for charities, but in its raw form the whole thing looks like cynical manipulation by the company. They get to reinforce their dress code, but...

A senior dev doesn't necessarily have the upper hand over a junior DBA. She has a different set of priorities to you, and in this case the structure of the...

The limiting factor for me is the cost. I've bought some, but the tools we're talking about cost corporate-scale amounts of money, and it takes a lot of justification to...

I don't know what to say - I just can't take it any more!! :hehe:

Are you looking for a raise Steve 😉

crussell-931424 (9/9/2014)

---

I hate estimates because they tend to be how long it would take to do something and we never seem able to dedicate that time to the project. There...