Great advice. I used to use log4net in my database applications (now I just use my own custom logger). I have debug statements scattered throughout my code, and...

In SQL 2000, it's the syscacheobjects table. There is a sql column and a usecounts column that can give you insights.

Robert Frasca (3/15/2010)

---

I've actually found that it's easier and faster to develop the OLTP model and the ODS in parallel. It also allows you to build a data source...

Good points made. I have never found using getdate() inside a SQL query to be problematic in my execution plans. However, if it's "best practice" to not do...

GDI Lord (3/10/2010)

---

Perhaps you should note in your article that the first script that you posted, the one that shows "TimesAccessed", only shows the data since the last restart of...

Agreed. It's easy for the scope of...

Thanks for your kind words...hopefully part 2 (scheduled for March 23) is less offensive 😀

Thanks for your kind words, thisisfutile. This being my first article posted on SSC, one of the things I've realized is that I clearly don't have the stomach for...

Gosh, these comments have taken a turn toward the hostile. I felt inclined to post this article because I am aware of the frustrations one can experience in trying...

I personally disagree with the assertion that the identity column is worthless in this example (personal bias notwithstanding). Granted, in database design, the identity column is unnecessary, and not...

gaurav.bhagat (3/2/2010)

---

I have another question from the article. Every PK in all three tables is called "id" which I have never used. I would name them UserId, groupId etc. Also...

I seem to be getting this response a lot (is it "bridge table" or "link table")...which is funny, because I've only ever called them "bridge tables".

As Karen Lopez points out,...

I really had no idea that my (somewhat unintended) misnomer would have caused such a stir. Indeed, I appreciate that some commenters have replied that this is basic relational...