Devils

Okay, folks. For those who are interested in our play project, the Universal ID Project thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1273368-61-1.aspx?Update=1

How much dynamic SQL do you use in your environment, ananda?

I think it...

How would you all like to design the system (and database) around this one: http://www.cnn.com/2012/03/26/opinion/frum-identity-cards/index.html?hpt=hp_bn7

Hi, back. Welcome to this week's...

Evil Kraig F (3/26/2012)

---

In the US, our Social Security Numbers are assigned for life and are supposed to be unique. However, our volume of illegal immigrant labor makes for...

Not really. That last column tells me that the number...

opc.three (3/26/2012)

---

Brandie Tarvin (3/26/2012)

---

Opc, you do realize I'm not the OP, right?...

Opc, you do realize I'm not the OP, right? I only posted...

I don't have Kimberly's contact information to email her the updated proc.

As far as my results go, they're pretty nasty.

CacheType Total Plans Total MBs Avg Use Count Total MBs...

If you run into the overflow error, like I did, try this:

SELECT objtype AS [CacheType],

COUNT_BIG(*) AS [Total Plans],

...

I'm not the OP, but I decided to try it anyway. I think I'm scared of my result.

Msg 8115, Level 16, State 2, Line 1

Arithmetic overflow error converting expression to...

Glad we could help.

yonder