rgtft (6/13/2011)

---

This has probably been asked before, but a quick search didn't show me what I wanted.

What is the thought on using bit fields for boolean values?

I'm creating a new...

I'm afraid I would disagree with Carlos above, however, my approach is very different for ultra-wides.

For the primary table, make sure it has your business keys and your 90% fields....

Yikes...

I'd start with a brute force timing test to figure out which of these statements are the culprits, then dig in from there. That's just too much to tackle...

Revenant (6/13/2011)

---

Good point, Steve. All too often the prospective employer already knows who will get the job but they have to go through the hoops and "interview" a certain...

Kinda.

In the FILES component, you...

I can answer one of these. What I officially know about Oracle you can fit in a thimble and still pour a shot into.

todinhkhoi (6/13/2011)

---

1. Can you tell me...

GSquared (6/13/2011)

---

Steve Jones - SSC Editor (6/13/2011)

---

My daughter was not thrilled with FL last weekend. Too hot for her. My wife canceled a trip to Baton Rouge with me for...

I'm not entirely sure I understand what the question was.

You're on the right track, as far as I can tell. You want the ForEach Loop control in the Control...

knechod (6/13/2011)

---

Sheesh! Once again, I am chastened by the "Everything you think you know is wrong!" fairy. I started off writing big CTE expressions, and they crashed under...

Jeff Moden (6/13/2011)

---

BWAA-HAAA!!!! 48 reads and 2-1/2 days later and no one has a compelling reason to use xp_CmdShell? Considering the number of posts asking how to use it,...

ANSI_WARNINGS should not be causing a 4 minute difference.

As you mentioned, but a recap for everyone, the only thing it does is fail divide by zero or overflows and warn...

Stefan Krzywicki (6/13/2011)

---

Lynn Pettis (6/13/2011)

---

Stefan Krzywicki (6/13/2011)

---

Brandie Tarvin (6/13/2011)

---

I think I figured out why the UG in Jax is so popular. According to some news item floating around, Jacksonville, FL...

patrick.doran (6/13/2011)

---

What about the case were you have multiple client databases on a single instance. You may have one client database and their queries that is overusing the CPU and...

Before I go haring off into the distance on a few assumptions, let's confirm them...

... What's a transaction to you?

... What types of transactions are you expecting to report?

... Where...

mnagasrikanth219 (6/8/2011)

---

Hi all,

I have some information(in a text file) in c:\ drive in each server,and we have like 100 servers.I would like to get the info in c:\ drive of...