Viewing 15 posts - 9,901 through 9,915 (of 14,953 total)
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...
April 20, 2009 at 8:17 am
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"...
April 20, 2009 at 8:13 am
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,...
April 20, 2009 at 7:58 am
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)
Stephen Hirsch (4/17/2009)
. . .cursors tend to be easier to write . . .
I think you'll get some argument on this. ...
April 20, 2009 at 7:48 am
Florian Reischl (4/18/2009)
What do you like more C# or VB.Net? It doesn't matter...
April 20, 2009 at 7:16 am
Try changing them to Left Outer joins instead of Right Outer. I confused myself by rewriting it a couple of times.
April 17, 2009 at 3:05 pm
Lynn Pettis (4/17/2009)
April 17, 2009 at 3:03 pm
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...
April 17, 2009 at 3:00 pm
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. ...
April 17, 2009 at 2:46 pm
Are you planning on asking the questions or on answering them?
April 17, 2009 at 2:44 pm
Jeffrey Williams (4/17/2009)
Lynn Pettis (4/17/2009)
I think he-who-should-just-go-away may be back. I wonder how he'll respond to my comment?
Hard to tell - then again, who can even understand him when...
April 17, 2009 at 2:43 pm
Take a look at this, http://www.sqlservercentral.com/Forums/Topic695359-338-1.aspx
Should get you what you need.
April 17, 2009 at 2:43 pm
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...
April 17, 2009 at 1:45 pm
Michael Valentine Jones (4/17/2009)
April 17, 2009 at 1:32 pm
bruce.trimpop (4/17/2009)
Mike C (4/17/2009)
bruce.trimpop (4/17/2009)
john.arnott (4/17/2009)
Stephen Hirsch (4/17/2009)
. . .cursors tend to be easier to write . . .
I think you'll get some argument on this. Cursors are...
April 17, 2009 at 1:19 pm
Viewing 15 posts - 9,901 through 9,915 (of 14,953 total)