Roman Pekar

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

Join two pandas dataframes with only end dates
add column value to an xml field as an attribute
What query should I write to calculate the cumulative salary of employees from the salary table
Fill several polars columns with a constant value
Pandas: drop_duplicates with condition
How to efficiently set column values based on multiple other columns
Find common values (Intersection) from one column of a table depending on the given values of second column of same table
Postgres PL/pgSQL recursive calculation
SQL Server Split one column into multiple columns
Polars timestamp synchronization lazy evaluation