Reputation
529
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 6 16
Impact
~25k people reached

  • 0 posts edited
  • 0 helpful flags
  • 35 votes cast
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
Sep
5
comment Merits of inserting to temp table and renaming versus just adding/removing columns
To your point, I was using SQLCompare as an example of where I see this practice by default. My deployment script, written by hand, can just as readily employ either tactic I mentioned... So I understand correctly I think you're objecting to the use of the tool rather than the scripting practice, no?
Sep
5
asked Merits of inserting to temp table and renaming versus just adding/removing columns
Jul
2
awarded  Curious
Jun
27
awarded  Notable Question
Jun
17
accepted Should I use a surrogate key in a mapping table?