Jeff Moden (4/20/2015)
dwain.c (4/20/2015)
Jeff Moden (4/20/2015)
L30 (4/15/2015)
Ah... apologies asene, I should have read it more thoroughly. So you want to query a nested group?If so I found this on StackOverflow
http://stackoverflow.com/questions/13914698/query-ad-group-membership-recursively-through-sql
Thanks for that link. It actually led me down a path where I found tons of MS documentation on the subject (I'd post some links but we know how unstructured MS online documentation can be. Gotta makes heads or tails out of it first.). I don't yet understand it all but I'm going to get there because it's going to help me automate the answer to the frequent question of "what are the effective privs that {someperson} has in the {somedatabase}"?
Jeff - I'd be obliged if you wrote up something on this. I've looked into it and it ain't particularly easy. Had I a definite need (other than curiosity) I probably could have cracked it. But my curiosity was never satiated.
NP. I have to write something about it even if it's for myself so I don't have to look at all the incomplete or difficult to follow documentation on it ever again. Might as well share. 🙂
Besides, I don't think I've seen you publish anything new on SSC in what now? A year or so?
I miss your articles.
My thought question: Have you ever been told that your query runs too fast?
My advice:
INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?
The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.
Need to UNPIVOT? Why not CROSS APPLY VALUES instead?[/url]
Since random numbers are too important to be left to chance, let's generate some![/url]
Learn to understand recursive CTEs by example.[/url]
[url url=http://www.sqlservercentral.com/articles/St