18,478 reputation
43369
bio website in.another.dimension
location Athens, Greece
age 46
visits member for 3 years, 8 months
seen 6 hours ago

Interests: math, programming and games, not necessarily in that order.


8h
revised Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
added 148 characters in body
8h
revised Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
added 823 characters in body
11h
comment Database design: Which will perform better, auto incremented column or a composite key for appointments
I meant that you should edit the "the identity key will be most efficient" to something like "to use the identity key as the clustered key will be most efficient"
11h
comment Database design: Which will perform better, auto incremented column or a composite key for appointments
I guess you assume that the primary key is the clustered one.
11h
reviewed Close Getting error creating database in SQL Server 2005
12h
revised Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
edited tags
12h
comment Database design: Which will perform better, auto incremented column or a composite key for appointments
With 500 rows per day, it doesn't really matter.
12h
comment Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
@ajeh: This is a derived table and not a correlated subquery. But yes, they are both referred under the term "subquery".
12h
revised Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
added 80 characters in body
13h
answered Re-writing a sub-select as a condition on a column generated with 'over (partition by …)'
14h
comment What are the dangers of non-IT managers using improper database terminology
I think, too, that the Workplace is a better site for this question. @BriansBoutique, you don't need to delete and re-post, you can flag for moderator's attention and request it to be migrated.
20h
revised Set bit in Table A if values are present in Table B
deleted 38 characters in body; edited tags
23h
comment WITH Clause UNION Issue
I totally agree with all the rest, so +1
1d
comment Why does this query take 32 sec to execute?
I'd try adding an index on (itemtype, id, historyid, status)
1d
reviewed Close The most important oracle database performance metrics
1d
reviewed No Action Needed Primary Key choice on table with unique identifier
1d
comment WITH Clause UNION Issue
It may happen but there is no guarantee that a CTE will be evaluated as many times as it is referenced.
1d
comment WITH Clause UNION Issue
You may also use UNION ALL and avoid the duplicate checks that UNION does.
1d
revised How do I count the number of different child id's belonging to a parent record?
added 171 characters in body
1d
reviewed Leave Open SQL Server migration from 2005/2008 to 2012