Roman Pekar

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

Parent Child relation in SQL Server
Polars - groupby mean on list
Distinct elements across subgroups for each group in polars
Finding word co-occurrences
Dynamic pivot data with multiple datatypes
Pandas: dropping all columns with nans, 0, and NA from DataFrame
Polars: Rolling groups with starting indices set by a different column
Make column values in a table have equal number of characters
get last node given the full path of all ancestor's node attributes using cte
How to read SQL database with Polars