michael 77302 (6/26/2013)

---

The odd thing is that none of the possible result sets give an Item with a length of 0 (that would result in the error). I think something...

Evil Kraig,

I do not have much time this day and the rest of the week, thus I am going to keep it short by making just points as a reply...

This is going to be a long reply, mostly because of much quoting, bear with me ?.

Evil Kraig F (5/8/2013)

peter-757102 (5/3/2013)

---

I would argue that most applications, notably the smaller to...

L' Eomot Inversé (5/3/2013)

---

Dynamic SQL??? What on earth would that be for? ... , every system I've been involved with since about 2000 has ended up (in some cases after...

neeraj.it (4/25/2013)

---

Based on my experience of a database where million of records are present and being operated for inserted/updated/deleted in a year. We were having proper constraints for data integrity...

“Give me a lot of data and I’ll save the world." That ought to be the model for data analysts. As SQL Server professionals and developers, we should be helping...

Just by looking at the code constructs, I recognise I do use this technique sometimes, but with severe moderation. Just in cases where there are other, more straightforward filters present...

This is a good example of why knowing the database matters!

I see too many work with data intensive systems where these kind of problems pop up that seem oblivious about...

Using a binary comparisons is a good speedup for specific cases and good to be aware of and certainly worth mentioning in bold with its benefits. What it is...

But that is the whole point of a trigger!

To implement some feature that works transparent...

Carlo Romagnano (2/19/2013)

---

I mainly use triggers to modify the behavior of third-party db and to alert users by e-mail that some value has been set. e.g. changing terms of payment...

Triggers are downright unavoidable for some comon problems. Unless you wrap all database actions in an interface represented by procedures (DB or otherwise) and consider the DB just dumb storage...

The cases in recent postings are much bigger than what I implemented so many years ago. I ran into problems pretty fast and in retrospect, my usage of the concept...

lnardozi 61862 (1/21/2013)

---

I made an entire subsystem for EAV data, in order to hold configuration information to be used by the entire enterprise.

There are stored procs, DTS packages, jobs, C#...

Usman Butt (1/17/2013)

---

Not always true 🙂 It really...