Viewing 8 posts - 436 through 443 (of 443 total)
Rows aren't MSSS securables which could be arguments of GRANT /REVOKE privileges. So you need your own dictionary or whatever storage to keep, grant, revoke privileges you need. So you...
February 20, 2014 at 2:40 am
Good work .
Considering performance gain I'd make some query optimization first. Looks like CTE may be a bit shorter, eliminating join which is only needed at final...
January 9, 2014 at 2:02 am
Hardly can imagine adding UNIQUE on a column just becase the column takes part in some join.
February 20, 2012 at 5:26 am
Adam Machanic (1/31/2011)
...Next, a unique constraint on the employee column, so that the same employee can't appear in the hierarchy twice under different managers...
This is correct for tree-like hierarchy only,...
February 1, 2011 at 2:06 am
WITH GroupMembers (Bottom, Child, ParentGroup, Level, hierarchypath)
AS
(
-- Anchor member definition
SELECT g.child as Bottom, g.child, g.parent, 0 AS Level, convert(varchar(max), g.child + '->' + g.parent) AS hierarchypath...
January 31, 2011 at 2:41 am
Ron,
I suggest you follow Jeff's advice and play with indexes.
NULLs may really affect execution plan.
November 29, 2007 at 12:54 am
A bit late, but i should mention one can find this design in many ERPs.
Just thing of 1000 or unkwnown and growing number of FKs.
November 28, 2007 at 1:13 am
Number type field value 0 is quite common real value.
I hardly can imagine how to tell the difference between 'real' 0 and 'NULL' 0.
November 28, 2007 at 12:51 am
Viewing 8 posts - 436 through 443 (of 443 total)