474 reputation
613
bio website
location Irvine, CA
age
visits member for 3 years, 2 months
seen Dec 17 at 20:02

I love creating elegant software solutions to novel problems.

Data is the future. Optimization is not our enemy.


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?
Jun
17
comment Should I use a surrogate key in a mapping table?
I understand your recommendation pertaining to the lookups and the range scan; I hadn't thought of that... But the ItemGroupId is certainly not sequential. Won't I run into performance issues in INSERT caused by the page splits? Or is that a consequence I should consider accepting for the resulting performance of the range scans?
Jun
16
revised Should I use a surrogate key in a mapping table?
added 11 characters in body
Jun
16
asked Should I use a surrogate key in a mapping table?
Jun
11
awarded  Popular Question