1,740 reputation
621
bio website
location Ukraine
age
visits member for 2 years, 10 months
seen 2 mins ago

Dec
15
revised Why can't I use a CASE statement to see if a column exists and not SELECT from it?
corrected grammar for better clarity
Dec
7
comment T-SQL View — How to 'pre-fetch' schema using scalar function, then populate using table query
I'm not entirely sure what you want here but it looks a little as if SET FMTONLY might be of help.
Nov
6
comment Best design to handle multiple query keys
@MinimeDJ: But if it's an "everything in one table" approach in particular, then it very likely will.
Oct
29
revised Query optimizer recommends adding index instead of using existing index
fixed typos
Oct
29
suggested approved edit on Query optimizer recommends adding index instead of using existing index
Oct
25
comment Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
What do you mean by "no subselects"? Does select ... from (select ... from (select ... from ... qualify as no subselects?
Oct
11
revised Very slow response even with a high number of available connections
formatting, grammar, punctuation
Oct
11
suggested approved edit on Very slow response even with a high number of available connections
Oct
6
comment How to add a default null row if no results from the dynamic pivot query
@user48768: By your original query I meant the one you want (and have been trying) to append an empty row to. That is, the entire PIVOT query would be the your query in the above suggestion.
Oct
6
answered How to add a default null row if no results from the dynamic pivot query
Oct
4
comment When you type an SQL query in interpreter, what does happen?
No, I didn't have issues with the missing comma (but thanks for it nonetheless). As I see it, the problem is the placing of the closing bracket: in my opinion, the bracketed expression should read (in SQL Server and other database engines).
Oct
3
comment When you type an SQL query in interpreter, what does happen?
However the four key stages (…) and other database engines are… – hm, this doesn't seem to make much sense. Perhaps the and other database engines should be in the brackets too.
Sep
30
awarded  Explainer
Sep
25
revised Truncated 200GB table but disk space not released
fixed typos
Sep
25
suggested approved edit on Truncated 200GB table but disk space not released
Sep
24
comment Alternatives for a LEFT OUTER JOIN query
It seems there is (or was) a bug with outer joins, specifically with right outer joins, in H2 according to information on this page. Note that apart from the fact that the issue was not with left outer joins, it also says there the bug was fixed in version 1.3, and, based on this, the latest version appears to be 1.4. Now, you said earlier that H2 was your choice. Did you happen to choose to use an old version of it?
Sep
19
awarded  Nice Answer
Sep
19
comment Relational Model vs. Database Products
@ThomasKejser: Well, this answer basically boils down to "When you come from theory (relational model) to practice (SQL, RDBMS), don't expect magic". That can be said about virtually any implementation of anything. In any event, is that a good answer to "Other than terminology (relation vs. table, attribute vs. column, tuple vs. row), what are some of the major differences?"?
Sep
18
answered Sum of two columns from pivot
Sep
18
comment Relational Model vs. Database Products
I think I can see your point now but I also disagree with what you call a difference (or even "the greatest difference"). I think the OP is looking for differences they will be able to observe (like something that one side has and the other doesn't: SQL has NULLs, RM has relational division…), and the fact that RDBMSes are iterative internally is not really observable by the user. On the other hand, it may explain existing differences, so probably you've answered some part of the question.