Roman Pekar

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

In Polars: what is the correct equivalent code for row_number() over(partition by) in BigQuery SQL?
How to extinguish cycle in my code when calculating EMWA？
Add business days including weekends
Check if one value exists in any rows of any columns in pandas?
How to filter on uniqueness by condition
Python Polars: Number of Rows until the next value in a group
Polars filter dataframe with multilple conditions
Impact on Performance When Using SQL-Like Padding in Polars
Minimum periods in rolling mean
select closest values from two different arrays