Reputation
2,898
Top tag
Next privilege 3,000 Rep.
Cast close & reopen votes
Badges
1 12 42
Impact
~166k people reached

Apr
5
awarded  Nice Question
Mar
19
awarded  Nice Question
Mar
8
awarded  Notable Question
Dec
7
asked Is is possible to convert SQL Server from single instance to failover clustered node?
Nov
17
awarded  Famous Question
Oct
7
awarded  Nice Question
Oct
2
awarded  Yearling
Aug
7
awarded  Constituent
Aug
7
reviewed Approve combine multiple rows into single row when its id is same
Jul
29
awarded  Nice Question
Jul
28
awarded  Notable Question
Jul
28
awarded  Caucus
Jul
15
comment Most efficient table storage for determining recurrence
A very astute observation! Somehow I got tunnel-visioned into the on-the-fly approach, when as you say, the pre-calculation of the actualized events makes retrieval almost immediate at the expense of storage and some limitations (e.g. generate last 50 years to next 50 years). Do you have any comments on a suitable data structure though?
Jul
14
asked Most efficient table storage for determining recurrence
Jun
18
awarded  Popular Question
Jun
10
awarded  Notable Question
Jun
4
awarded  sql-server
Mar
18
awarded  Notable Question
Feb
19
awarded  Popular Question
Dec
1
awarded  Popular Question