ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)It's unclear how a table containing only Title + Author, and duplicates allowed, would be used by an application. If someone wanted to know what titles...

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

---

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

---

ZZartin (2/19/2015)

I don't disagree that most tables probably will and should but there's certainly cases where you might not have a need...

Alvin Ramard (2/19/2015)

---

This editorial came on an interesting day.

A few hours ago I decided I need to get my hand on a cheaper option to Erwin or DB Artisan. ...

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

---

ZZartin (2/19/2015)

I don't disagree that most tables probably will and should but there's certainly cases where you might not have a need for or a possible...

Depending on the level of detail in the record, an event can be uniquely identified by a combination of time, place, actor, and action. In this case the Account number...

I wouldn't consider myself "lazy", but I do try to maintain only a small manageable number of priorities that I perceive "matter". Most IT developers do, which is why we...

ZZartin (2/19/2015)

I don't disagree that most tables probably will and should but there's certainly cases where you might not have a need for or a possible primary key.

To...

Whipping up a complete stored procedure within a minute in front of a crowd is not what I do. Although looking at some of the poorly thought out legacy stored...

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

---

Grant Fritchey (2/19/2015)

---

shane.green 1227 (2/19/2015)

---

There are exceptions to every rule, so while "All tables should have at least one index" is good rule - it doesn't...

If you choose to compare a column to itself, then understand that it's not functionally the same as "1 = 1", the result will exclude rows with NULL values.

create...

Grant Fritchey (2/19/2015)

---

shane.green 1227 (2/19/2015)

---

There are exceptions to every rule, so while "All tables should have at least one index" is good rule - it doesn't mean that should not...

Eric M Russell (2/18/2015)

---

Resender (2/2/2015)

---

ok this is something of a best practice of mine in my queries

I always do

WHERE 1 = 1

I can't remember where I picked this habit up...

Resender (2/2/2015)

---

ok this is something of a best practice of mine in my queries

I always do

WHERE 1 = 1

I can't remember where I picked this habit up and I'm one...

butcherking13 (2/18/2015)

---

I was hoping the tenured DBA’s would chime in on this. I work with a developer who has more experience as I am a very junior DBA. She is...

djackson 22568 (2/18/2015)

---

...

It is also against the law to kill and steal, but people do it. Laws don't prevent anything, they discourage. Governments and corporations across the...