455 reputation
512
bio website
location Reno, NV
age
visits member for 2 years, 11 months
seen Aug 25 at 17:08

I love creating elegant software solutions to novel problems.

Data is the future. Optimization is not our enemy.


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?
Mar
20
accepted Should I nest dependent outer joins in SQL Server?
Feb
13
accepted Can I alter a view being referenced with schemabinding if the change fulfills the binding requirement?
Feb
12
asked Can I alter a view being referenced with schemabinding if the change fulfills the binding requirement?
Feb
10
awarded  Yearling