438 reputation
410
bio website
location Reno, NV
age
visits member for 2 years, 6 months
seen Apr 7 at 23:53

I love creating elegant software solutions to novel problems.

Data is the future. Optimization is not our enemy.


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
Feb
10
comment Should I nest dependent outer joins in SQL Server?
Why, then, do they produce different query plans without using the FORCE JOIN ORDER hint?
Feb
10
comment Should I nest dependent outer joins in SQL Server?
@AaronBertrand I am normally in the camp of going with what's more understandable even if it means giving up performance. I have not tested this at scale... I was thinking there might be a significant fundamental difference in how the query is planned.
Feb
10
comment Should I nest dependent outer joins in SQL Server?
@AaronBertrand somewhere toeing the line between "best practice" and "better performance"
Feb
10
comment Should I nest dependent outer joins in SQL Server?
@MichaelJSwart your blog only appears to discuss when the dependent JOIN is an INNER JOIN
Feb
10
revised Should I nest dependent outer joins in SQL Server?
added fiddles
Feb
10
asked Should I nest dependent outer joins in SQL Server?
Jan
29
awarded  Popular Question