On occasion I've used: SELECT.. WHERE 1 = 0. For example, I may want to select into a temp table that is derived from another table but initially empty. Also,...

So, where does an Entity Framework developer land when you...

Regardless of where the remote server is located, so long as there is a LAN connection between, then latency is not an issue when pulling across hundreds or a few...

That's a self-answering question. If you want to do something more, then you have to become something else besides a senior level DBA....

jackson.fabros (2/19/2015)

---

I've read (and enjoyed) the original post that focused primarily on what a DBA should do on day one.

Aside from the obvious (stop, listen, take notes, repeat),...

OK

When a table is non-clustered heap, SQL Server adds...

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...