Once again, such good explanations/teaching.

I'm like an earlier poster. I haven't been able to find an advantage to the pivot syntax. (Though unpivot came in handy once.) ...

Beyond never creating the data in the first place or locking it up so that no one can ever do anything with it,...

Brian:

What you are saying now makes better sense to me. What got lost in this discussion (and most discussions like it) is the last part of your last posting,...

K. Brian Kelley (8/13/2008)

Ah, you mean delete all the data from the table.

I see the difference, but...

I didn't know about that site. Looks like it could be a good resource for me. Thanks for...

In smaller organizations where you have the opportunity to know the people, this can certainly work. However, there's always the possibility in a small shop where the boss' "Chosen One"...

Exactly! I think I will be tasked with creating a web app in the not too distant future. At that point, the game...

My favorite line in the article is "...they don't get the job unless I trust them." I know I take that in a different way than the author meant,...

Such a great article. I really like how you took the time to explain things. I came onto the computer scene when issues like that were still talked...

RBarryYoung: Thanks so much for your information. I had no idea that there was such a discipline around this issue. Very interesting stuff and good points. Thanks....

It's not a question of whether you *can* get information about someone, but a question of whether you *should*. It is a question of ethics. There is a...

I appreciated the article and it is new to me. Why did I like it? Because so far, my databases are so small relatively that stressing over database...

hee, hee. Alas, I like my current job.

MentalWhiteNoise's post best represents my thoughts.

Here's my experience: For 10 years now, I've been using a mix. I use stored procedures where it makes the most sense and direct...

Oh ya! I remember now. Thanks!!