Baby

SQLRNNR (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

SQLRNNR (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

ChrisM@Work (6/25/2014)

---

djj (6/25/2014)

---

Just saw a post (on another site) that the person had part of a query list but no quest was asked. ...

Explode

Okay, that was one of the cooler questions I've seen. I've never used ESCAPE before and I've never even thought of putting search patterns into a table. Your...

djj (6/25/2014)

---

Koen Verbeeck (6/25/2014)

---

ChrisM@Work (6/25/2014)

---

djj (6/25/2014)

---

Just saw a post (on another site) that the person had part of a query list but no quest was asked. Someone posted "What...

Compress

Doctor (had to look that one up)

Stefan Krzywicki (6/24/2014)

---

Lynn Pettis (6/24/2014)

---

Lynn Pettis (6/24/2014)

---

Ed Wagner (6/24/2014)

---

Lynn Pettis (6/24/2014)

---

< rant >

Help me, help me. I don't know how to use BOL or Google! I need to...

Did you drop your nonclustered indexes first?

For details on CXPACKET, Paul's blog on wait stats is at http://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/.

Lynn Pettis (6/24/2014)

---

Lynn Pettis (6/24/2014)

---

Ed Wagner (6/24/2014)

---

Lynn Pettis (6/24/2014)

---

< rant >

Help me, help me. I don't know how to use BOL or Google! I need to add 10...

It adds to the days because under the hood, a datetime is really two integers. The first integer is the number of days since 1/1/1753. The second integer...

Don't you mean 365.25 times? Or would that be add 365.25 to today 10 times? It all depends...

Lynn Pettis (6/24/2014)

---

< rant >

Help me, help me. I don't know how to use BOL or Google! I need to add 10 years to the current date and...

Luis Cazares (6/24/2014)

---

Congratulations Koen. You're certainly one of the top posters on Bi.

On a completely different subject, I'm taking 20467BC course this week and found some surprises like using...

Werthers