Grant Fritchey (3/27/2014)

---

jcrawf02 (3/27/2014)

---

We have a written test we use to weed out people who don't know the first thing about SQL (report writing position, not DBA stuff), it's pretty...

It could even be scary...

Great question Andy

But... I've been working in SQL for 10 years... I'm a senior DBA!

jasona.work (3/21/2014)

---

Well, today is going to be a big day for the wife and I, almost as big as when I switched jobs...

Today we meet with the builders to go...

Mad Myche (3/19/2014)

---

I've used this before for parsing IP Addresses as suggested.

Re-reading the article today made me realize that I can use it in more ways, and what took me...

Rich, Jason, Jeff, and Dwain - I'm glad you liked it, and I hope you learned from it.

You might want to consider replacing all of those table variables with temp tables. The results may surprise you.

Just noticed a change here, and I thought I'd let others know about it.

If you like to underline url's that you type in, you need to go [ u ]...

http://technet.microsoft.com/en-us/library/ms177634.aspx

FROM (derived_table_query) AS <derived_table_alias>

ON derived_table_alias.column = other_table.other_column

Sean Lange (2/28/2014)

---

JoshDBGuy (2/28/2014)

---

Do you have a best practice for cursors? Just don't use them at all or only in certain situations? I tend to use them for small sets...

Suggestions:

1. Include running totals utilizing the SQL 2012+ enhancements to the OVER clause (yes, the QU is still faster... but this is documented in BOL, and still beats everything else,...

Thought you were going to be taking a sabbatical?

Nice article Dwain. Keep them coming.

I knew it. Heck, we all knew this about you!