20,351 reputation
43575
bio website in.another.dimension
location Athens, Greece
age 46
visits member for 3 years, 10 months
seen 11 hours ago

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

Favourite numbers: Surreals


21h
revised Need help in incrementing the date in oracle
added 11 characters in body
21h
comment New Index on table cause table to be locked really often
I'd say your problem is EF and the horrible queries it produces. I'd prefer an index on (TrackerId, Position) though (even without modifying the query) for this TOP 1 .. ORDER BY Position DESC
2d
revised sql query self outer join
added 43 characters in body
2d
comment How to dynamically alias subquery column
Better way in what aspect? Performance?
2d
comment sql query self outer join
You edited the question, fine. Why don't you answer what DBMS this is for? Voting to close as "unclear". When you decide that you do want help in this, add the CREATE TABLE statement as well.
2d
revised Get products of category plus all child categories till leaf nodes
added 2 characters in body; edited tags; edited title
2d
comment How to dynamically alias subquery column
Did you try the solution provided in that answer? Why did it not work?
2d
comment Does MariaDB Support Materialized views?
I think no. But it has computed columns which can be persistent. See their docs: VIRTUAL columns
Dec
17
comment How to Shift a column up in a ring buffer?
How many is "many"? 10, 100, 2000 columns? And I did not suggested you modify any rows. My suggestion was exactly the opposite, to use INSERT instead of (modifying) UPDATE.
Dec
17
comment How to Shift a column up in a ring buffer?
Why not add a new row every time and when you want the average just calculate it from the last 10 rows (10 max IDs, 10 max dates, whatever)? I think it will be more efficient to be inserting 1 row than updating 10 every time.
Dec
17
revised Retrieving n rows per group
added 233 characters in body
Dec
17
answered Retrieving n rows per group
Dec
17
revised the <set clause>'s <multiple column assignment>
added 6 characters in body
Dec
17
revised the <set clause>'s <multiple column assignment>
added 70 characters in body
Dec
17
answered the <set clause>'s <multiple column assignment>
Dec
17
comment We are trying to set up a database to be able to read and write messages on a website
I think this question belongs to SO as the answer will depend on the details of what you are using (asp, php, javascript?)
Dec
17
reviewed Reviewed We are trying to set up a database to be able to read and write messages on a website
Dec
17
comment Sorting a table based on nullable Position field that has to match the position on the result set
Quite complex requirements. What is not clear is what should happen in the case of two rows with same position (ie. 9). The one with the oldest date ok, takes precedence and goes to position 9. Where does the other go? To position 10? What happens if there is another row (or more!) with position 10?
Dec
16
comment Unique index on columns which are allowed to be NULL
I agree with @a_horse_with_no_name, the linked question is an identical problem and has the same solution. The various price columns should not be in the unique constraints anyway.
Dec
16
reviewed Leave Open GROUP BY Returning Different Totals