462 reputation
513
bio website
location Irvine, CA
age
visits member for 3 years
seen yesterday

I love creating elegant software solutions to novel problems.

Data is the future. Optimization is not our enemy.


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
Mar
31
comment Not exists/Where NOT in
How do you know that the REF record belongs to the INQ record? Just because they are adjacent? Because their clustered indices are sequential? Along that line, is a REF to be ignored always when its clustered index is next after an INQ? Is there only one INQ permitted per date per Customer?
Mar
30
comment How should I limit a table to N rows, discarding oldest?
@MartinSmith and I'd goad you more if I, too, weren't on vacation!
Mar
30
accepted How should I limit a table to N rows, discarding oldest?
Mar
30
comment How should I limit a table to N rows, discarding oldest?
@MartinSmith Please convert you comment to an answer. While Aaron's solution is sufficient in my use case I think your suggestion is actually more fitting the "spirit" of my quesion.
Mar
30
comment Efficiently storing irregular/repeating intervals (think calendar/events)
How complex is your scheduling requirement? "First Monday of every month" is, perhaps, very different from "Every third Monday" or "First sunday, annually, after the vernal equinox"
Mar
30
comment How should I limit a table to N rows, discarding oldest?
@Verace Imagine that I have many of these tables and they get a row added every few seconds.
Mar
30
comment How should I limit a table to N rows, discarding oldest?
Good answer, will accept. I guess I was hoping there was some fixed table property to limit the number of rows in this FIFO manner... I guess not!
Mar
30
comment How should I limit a table to N rows, discarding oldest?
@AaronBertrand it can be cleaned periodically.
Mar
30
asked How should I limit a table to N rows, discarding oldest?