710 reputation
2819
bio website
location Austria
age
visits member for 3 years, 4 months
seen Aug 19 at 18:42

C++

Link of the day: Stop Software Patents (by http://www.ffii.org/)


Aug
28
awarded  Famous Question
Aug
6
awarded  Notable Question
Jul
2
awarded  Curious
Jun
25
accepted Can I get some rationale from the Optimzer why it chose a certain explain plan?
Jun
25
asked Can I get some rationale from the Optimzer why it chose a certain explain plan?
May
4
awarded  Yearling
Mar
18
awarded  Popular Question
Feb
13
awarded  Popular Question
Feb
11
awarded  Famous Question
Dec
14
revised Query with large number of or'ed predicates on the same column?
added 594 characters in body
Dec
5
comment Query with large number of or'ed predicates on the same column?
@Phil - well currently no. There is just this one table that is first queried for a few hundred records and later the data from this few hundred records (that is still cached by the client) needs to be matched against the whole table. Would it make sense to have something like a "scratchpad" table inside the the db? Is this common?
Dec
5
revised Query with large number of or'ed predicates on the same column?
added 58 characters in body
Dec
5
asked Query with large number of or'ed predicates on the same column?
Aug
30
awarded  Notable Question
Jun
19
comment What can I add to a server to make SQL restores faster?
OT: " consider SSDs. ... I wouldn't want to use them on something that doesn't get re-created on a regular basis" ... why?
May
28
comment How do you store tabular data in an RDBMS?
@JNK: Not sayin' anything. A generalized answer probably would include a fully normalized model. That still leaves the query part of the question open. I though it might be an interesting problem to work on. Maybe I'll come up with an answer of my own and probably I'll have to ask for query advice along the way, but that's for then.
May
28
comment How do you store tabular data in an RDBMS?
@JNK - The linked question asks about measurement values. We have real world use cases where one measured sample contains above 2k or 3k channels I think, that's why I chose 10k here, I could have said 4k, but would it really make any difference?
May
28
asked How do you store tabular data in an RDBMS?
May
28
accepted Are individual queries faster than joins?
May
28
comment Are individual queries faster than joins?
@DavidAldridge: Hate to break it to you. Stuff is mostly run by people (initially) lacking the skill to do so. That's how we got where we are. :-P