Reputation
620
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 7 17
Newest
 Yearling
Impact
~37k people reached

  • 0 posts edited
  • 0 helpful flags
  • 40 votes cast
Apr
13
accepted Is SYSUTCDATETIME a safe primary key?
Apr
13
revised Is SYSUTCDATETIME a safe primary key?
PK not CI
Apr
13
asked Is SYSUTCDATETIME a safe primary key?
Feb
22
awarded  Yearling
Oct
30
awarded  Critic
Aug
18
awarded  Nice Question
Aug
3
awarded  Caucus
Jun
24
awarded  Famous Question
Mar
22
awarded  Popular Question
Dec
4
comment How should I delete branch from adjacency list in SQL Server?
I wonder if this can be accomplished in a recursive CTE rather than recursive sproc calls?
Dec
3
comment How should I delete branch from adjacency list in SQL Server?
My current implementation runs L deletes where L is the number of levels. Your implementation runs N deletes, where N is the number of nodes.
Dec
2
revised How should I delete branch from adjacency list in SQL Server?
added 88 characters in body
Dec
2
comment How should I delete branch from adjacency list in SQL Server?
@a_horse_with_no_name actually, I couldn't even if I wanted to. ON DELETE CASCADE is not allowed on adjacency lists like this that could by cyclic.
Dec
1
comment How should I delete branch from adjacency list in SQL Server?
@a_horse_with_no_name That approach isn't very effective for me because I have additional logic I need to do given the IDs of the deleted nodes.
Nov
27
awarded  Notable Question
Nov
26
revised How should I delete branch from adjacency list in SQL Server?
edited title
Nov
26
asked How should I delete branch from adjacency list in SQL Server?
Nov
12
accepted How to migrate between schemas in bulk in SQL Server?
Sep
24
awarded  Autobiographer
Sep
5
accepted Merits of inserting to temp table and renaming versus just adding/removing columns