Roman Pekar

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

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
SQL Server : Group by string concatenation
Query to get list active queries in my SQL Server
Query from multiple column
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