SELECT

v,

v&1 AS bit1,

v&2 / 2 AS bit2,

v&4 / 4 AS bit4,

...

FROM

table

You're looking for the bitwise operators, &...

CGSJohnson (4/7/2011)

---

3. If the configuration and data tables will be read (the final read) from the information provided in the "connection" switch, and not the information stored in the database,...

If you can avoid this I would. There are times things like...

Brandie: It's about 6 quadrillion larger then the target system can handle, especially in its rollup calculations.

Jeff Moden (4/7/2011)

---

Are there any known limits for the data so you can remove...

CirquedeSQLeil (4/6/2011)

---

You could see performance gains if you did get an SSD. Better yet, try getting a fusionIO card. Check them out at fusionio.com[/url]. Think of an...

Ai ai ai. This made my head hurt. 🙂

This link may help if you're used to how 2k5 works for SSIS configs and commandline settings: http://msdn.microsoft.com/en-us/library/bb500430.aspx

CGSJohnson (4/6/2011)

---

In developing an...

Chrissy321 (4/6/2011)

---

See two proposed data models below. The second model seems more traditional to me but my experience is mostly with transactional systems. The first model seems more flexible to...

Thanks for the comments guys. I was pursuing something similar but time is against me. I've got a few more tricks up my sleeves and I'll share them...

rmechaber (4/6/2011)

---

Craig Farrell (4/6/2011)

---

There's nothing in those estimated plans that pop out and bite me... but they're estimates. My guess is there's a significant difference between estimated and actual....

GSquared (4/6/2011)

---

Brandie Tarvin (4/6/2011)

---

Stefan Krzywicki (4/6/2011)

---

Brandie Tarvin (4/6/2011)

---

Stefan Krzywicki (4/6/2011)

---

I remember watching both The Monkeys and Original Star Trek as a kid, but they were both in reruns at that...

Hey guys, need some opinions on something. I know there is no 'real' solution here.

http://www.sqlservercentral.com/Forums/Topic1089499-361-1.aspx

There's nothing in those estimated plans that pop out and bite me... but they're estimates. My guess is there's a significant difference between estimated and actual. Can you...

Well, Wayne asked me to drop in with another viewpoint just to try to get as many as possible.

ORM = Incredibly annoying to inherit. ORM is (personal experience opinion)...

Brandie Tarvin (4/6/2011)

---

Non sequitur. I wrote my first web comic. It was put up this morning as a guest comic at Complex Actions. My sister did the artwork.

http://www.complexactions.com/archive/G03.shtml

I hope you...

Look into temporary (#tbl) tables and table variables (@tbl), they were built to do exactly what you're looking for. You join them back into the next query in the...