Roman Pekar

Roman Pekar has asked 12 questions and find answers to 389 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

select closest values from two different arrays
python ordereddict when the key is a "numeric string"
DB cartesian product on same table
SQL Server stored procedure that returns processed records number
Window Functions or Common Table Expressions: count previous rows within range
how to replace elements in a column using pandas
query a pandas dataframe based in index and datacolumns
Find movies with highest number of awards in certain year - code duplication
Determine if a given timestamp is within the same day in postgresql
datetime Cast or Convert? [duplicate]