Roman Pekar

Roman Pekar has asked 12 questions and find answers to 426 problems.

Stats

About

Constant battle for concise and elegant solutions.

ormeugensson at gmail.com

Roman Pekar questions

Unique filtered index and indexed view are ignored by optimizer
Avoiding "An INSERT EXEC statement cannot be nested"
Merge with Unique filtered index
Pandas remove column by index
Efficient way of storing date ranges
SQL: do we need ANY/SOME and ALL keywords?
Is there any reason why min and max not working on bit fields
Conditional UNION ALL in table function
How to get column-level dependencies in a view

Roman Pekar answers

Replace string in file using a SQL procedure
Trigger for 2 Tables
change in value running total of time between
SQL: JOIN with 'near' match
INSERT INTO PostgreSQL
Select users who did a purchase after a search where some conditions apply in PostgreSQL?
different results when using query with variables and without variables
Inserting whole sql script in variable
Generate all possible permutations of subsets containing all the element of a set
postgres: get top n occurrences of a value within each group