Laerte POltronieri Junior (4/29/2009)

---

I use sql server 2008.

I want to create a clr stored procedure and send a datatype type Table Valued Parameters to this clr.

And this clr will do...

There is also a hybrid approach that you can take. Instead of just 20,000 bit flags, in 2500 binary bytes or 20,000 records, break your flags into "zones" or...

Paul White (5/1/2009)

---

If there are to be a large number of users and updates would be frequent (the number of bits implies that you are recording pretty much every piece...

Thanks David. Yeah, it's easy to see with the right perspective.

Edit: spurious post. No one has replied to it yet, but I still cannot delete it, so I have erased it instead.

Tom.Thomson (4/30/2009)

---

RBarryYoung (4/15/2009)

---

Just because pure set-based SQL may not be sufficient for a particular task does not mean that that justifies Cursors or loops in SQL. There are still...

Tom.Thomson (4/29/2009)

---

dbishop (4/14/2009)

---

That is the point I was making. The author assumed that by changing his code from the individual steps (procedures) to Cookies, with chocolate chips, all of a...

Paul White (4/30/2009)

---

RBarryYoung (4/30/2009)

---

Dude, what is going on with your code-window font sizes lately? They are showing up in my Firefox browser larger than PowerPoint letters. Makes them...

It's a common perception Wayne, and sometimes true. But what's easy to overlook is that with a really super-efficent function like AVG() the primary loop-path is so tight that...

IlanP (4/24/2009)

---

...

(A)When loading the user, the application will need to pull the entire list of settings for that user.

(B)Updates to these settings will be additions only (turning on of the...

WayneS (4/30/2009)

---

Glad to hear you're home, and good to see you back here! How long of a recovery period are...

WayneS (4/30/2009)

---

RBarryYoung (4/30/2009)

---

pdb DBA (4/30/2009)

---

Well here's my thinking (which is probably a bit twisted...) on it and why this didn't occur to me at first...

Sure, I know it *returns* the...

I see a lot of folks trip over this: the "AVG() Overflow syndrome", as I like to think of it.

What's interesting about it is no one ever calls me about...

pdb DBA (4/30/2009)

---

Well here's my thinking (which is probably a bit twisted...) on it and why this didn't occur to me at first...

Sure, I know it *returns* the same value,...

The only problem that I have ever had with AdventureWorks is finding the kits. It was crazy how hard it used to be to find the dang things. ...