Just like in the Snickers commercials, people tend to get grumpier when low on food.

While that is partially true for me, I know I get grumpier if it is all...

I had a conversation just last week with a client that said DBAs are hoarders. My response to him was along the very same lines as Andy laid out...

I'd probably go with setting. But the question is fine...

+2

RLilj33 (6/6/2014)

---

HanShi (6/6/2014)

---

I was in doubt, because I found it difficult to get the intention of the question (perhaps because I'm not native English speaking). Did I need to take...

Koen Verbeeck (6/6/2014)

---

I think I have finally met the "exception on the rule" for SELECT *.

Select on an Oracle view with all the of the columns in the SELECT clause:...

Sean Lange (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Sean Lange (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Sean Lange (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Sean Lange (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Luis Cazares (6/5/2014)

---

TomThomson (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

SQL is delicious (6/5/2014)

---

...also labors under the delusion that the...

Sean Lange (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Sean Lange (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Sean Lange (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Luis Cazares (6/5/2014)

---

TomThomson (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

SQL is delicious (6/5/2014)

---

...also labors under the delusion that the American education system...

Sean Lange (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Sean Lange (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Luis Cazares (6/5/2014)

---

TomThomson (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

SQL is delicious (6/5/2014)

---

...also labors under the delusion that the American education system is worthless and...

Luis Cazares (6/5/2014)

---

Sean Lange (6/5/2014)

---

SQLRNNR (6/5/2014)

---

Luis Cazares (6/5/2014)

---

TomThomson (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

SQL is delicious (6/5/2014)

---

...also labors under the delusion that the American education system is worthless and that our...

Luis Cazares (6/5/2014)

---

TomThomson (6/5/2014)

---

Luis Cazares (6/5/2014)

---

Koen Verbeeck (6/5/2014)

---

SQL is delicious (6/5/2014)

---

...also labors under the delusion that the American education system is worthless and that our master's level work is the...

Sean Lange (6/5/2014)

---

I am just going to leave this here...

http://www.sqlusa.com/bestpractices/%5B/url%5D

Don't worry there is soap for your eyes. Then if you read some of the content you may want to find...

boom

steve.bailey 29413 (6/5/2014)

---

TRUNCATE TABLE isn't a fully logged operation but as Sujeet's findings show it is logged in the transaction log (It's always logged regardless of recovery model - I'd...

Truncate is still a logged operation in the other models.

The myth has been long...