You should be able to query AD data at runtime, instead of trying to keep it in SQL tables. That way, you don't have to worry about the data...

On the down OLTP server, my first question would be, "what do you mean 'down'?". There's a big difference between "the web pages are slow and customers are complaining"...

That's not part of the addition. That's just setting up a framework to run it. Run the query without that, with the numbers directly in the Where clause,...

bruce.trimpop (4/17/2009)

---

GSquared (4/17/2009)

---

bruce.trimpop (4/17/2009)

---

Mike C (4/17/2009)

---

bruce.trimpop (4/17/2009)

---

john.arnott (4/17/2009)

---

I think you'll get some argument on this. ...

Florian Reischl (4/18/2009)

---

I have a short question depending on the article I intend to write (CLR solutions to split strings).

What do you like more C# or VB.Net? It doesn't matter...

Try changing them to Left Outer joins instead of Right Outer. I confused myself by rewriting it a couple of times.

Lynn Pettis (4/17/2009)

---

I wonder if he will be able to put 2 and 2 together and realize he is in the same bucket of slop as that second contractor I...

I guess I don't understand your question. If you're creating AD groups, wouldn't you store those in the Active Directory? That's not in SQL.

If you need to pull...

I think you may be confusing table variables with something else. Or using them in a way I'm not familiar with. Table variables are not inherently slow. ...

Are you planning on asking the questions or on answering them?

Jeffrey Williams (4/17/2009)

---

Hard to tell - then again, who can even understand him when...

Take a look at this, http://www.sqlservercentral.com/Forums/Topic695359-338-1.aspx

Should get you what you need.

Is there any chance you can redesign that second table? A vertical arrangement is going to be MUCH more efficient, and the horizontal one will cause problems later in...

Michael Valentine Jones (4/17/2009)

---

OK, as long as we are doing useless SQL, I want to add numbers together without using any Arithmetic, Logical, Assignment, String, Bitwise, or Unary Operators or...

bruce.trimpop (4/17/2009)

---

Mike C (4/17/2009)

---

bruce.trimpop (4/17/2009)

---

john.arnott (4/17/2009)

---

I think you'll get some argument on this. Cursors are...