Roman Pekar

Roman Pekar has asked 13 questions and find answers to 474 problems.

Stats

About

Constant battle for concise and elegant solutions.

ormeugensson at gmail.com

Roman Pekar questions

refer to value of unnest (or other srf) in WHERE
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

Follow sort after a group_by in polars
Polars apply function to check if a row value is a substring of another string
Employees and managers in the same Project? SQL
Pandas - Comparing column values with value in a dictionary
SQL Server : birthdays on Leap Year
MySql: join from other table and count results
Memoize a costly computation of a data frame
Closure Table INSERT statement including the level/distance column
Rolling KPI calculations in polars, index not visible
Return two nearest / closest rows above and below a target value in Polars