The spam has hit with a vengeance. I'm inclined to agree with a post a while back that it's an actual person, not an automated process. The rate...

Greg Edwards-268690 (11/22/2014)

---

Jeff Moden (11/22/2014)

---

Heh... I've reached the "Overflow Exception" a couple...

Now that is just too funny - a bar called R-Bar. Jeff would have to bring the industrial pork chop launcher and spike the pork chops with high explosives....

spaghettidba (11/21/2014)

---

Ed Wagner (11/21/2014)

---

I must admit I was excited when I saw this, but sys.dm_os_volume_stats is for 2012 and later. I'm still on 2008, so I'm out of luck.

Thank...

lshanahan (11/21/2014)

---

Recently been trying to wrap my brain around APPLY and it's sibling CROSS APPLY as I have some situations where they could prove useful.

I'm using 2005 at the moment,...

LoudClear (11/21/2014)

---

I, like Steve, have been intentional about trying to stretch my SQL skills this year. Part of that plan has been that I now follow a number of...

There's no shortage of ways to do the actual conversion, but I think the most important point to understand the data type to use. If you store your dates...

I must admit I was excited when I saw this, but...

I use tally tables and APPLY all the time. They're very efficient approaches to accomplishing the work that's needed.

I've used symmetric keys, but not nearly as much. They...

+1. Good question, but the explanation could have been a whole lot better.

Magnetic

Cheat

Growth

Fennel

Sean Lange (11/20/2014)

---

Koen Verbeeck (11/20/2014)

---

And VARP is the only function with a name less than 5 characters! :w00t:...