Jeffrey Wiener (8/31/2010)

---

But then, for a very common task as described in this article, the most optimal solution is to code it with dynamic SQL. This then forces the...

Another great...

Tony Alicea (8/31/2010)

---

As far as efficiency - in 14 years I've always found this technique to be acceptable in the realm of efficiency and (especially in the old days) was...

Sort of... it's for forms based authentication on a web page. Instead of creating the M:N association...

Why not...

Eric Russell 13013 (8/30/2010)

---

Data integrity and constraint begins with choosing the appropriate data type. Obviously (to most of us) integers should be contained in an Integer data type and monetary...

Yah I noticed that I had missed about 50 forums or so... some organized one way, others differently... 🙂

tim.stevens (8/24/2010)

---

This is one of the best concise treatises on NULL I have seen. Your adminition about a well architected database design not allowing NULLs for any columns is...

Blah Forums flippd out on me for a moment... this was a double post of my other one. 🙁

Tom Carnahan (8/24/2010)

---

Good article ...

---

A topic I wish had been addressed is how to handle nulls in datetime fields. I think that you do the following. Let me know...

webrunner (8/18/2010)

---

What I am wondering is, if hypothetically this restriction were lifted and one could set the recovery model of tempdb to Full, what would be the impact of a...

webrunner (8/18/2010)

---

I'm grateful for the point. It was easy for me - which I can't say about too many questions, but I'm especially glad I didn't second-guess myself into a...

michael.kaufmann (7/14/2010)

---

My gutt told me to go for option 1, but not because of it running faster, but because I wondered why one would change a non-nullable column to nullable...

Add me to that boat. I didn't even see the semi-colons... I've trained myself to ignore them when they aren't required... and since we didn't need one at all...

webrunner (6/28/2010)

---

Everything necessary regarding the question's typo has already been covered. But I want to thank those who pointed out that "-0" (impossible value, of course, because 0 can be...