Denis Rubashkin's user avatar
Denis Rubashkin's user avatar
Denis Rubashkin's user avatar
Denis Rubashkin
  • Member for 6 years, 1 month
  • Last seen more than a month ago
7 votes

Writing a T-SQL stored procedure to receive 4 numbers and insert them into a table

7 votes

Flatten array with OPENJSON: OPENJSON on a value that may not be an array? [ [1] ], vs [1]

7 votes
Accepted

Looking up which record(s) correspond to a specific resource description in dm_tran_locks

7 votes
Accepted

"dateformat" independent form of datetime string in query for SQL Server?

7 votes
Accepted

Force_legacy_cardinality_estimation hint questions

6 votes
Accepted

SQL Query returning same value while using where 1 condition

6 votes
Accepted

Distributed AG on SQL Server 2017 Standard Edition?

6 votes
Accepted

Can a non-clustered index be transformed to a covering index in SQL Server?

5 votes
Accepted

Getting Index Scan instead of a possible Index Seek?

5 votes
Accepted

Performance difference between environments when adding column

4 votes
Accepted

How to get rid of comma if no other value comes after the string

4 votes

Improper use of logical operators has led to poor query performance

4 votes
Accepted

Search plan cache for all query plans using a given index?

4 votes

Get ids only where one id is null and other isn't

4 votes

Removing duplicates values with join

4 votes

updating statistics using STATS_STREAM or WITH FULLSCAN?

4 votes

Can't add server user to database role

3 votes
Accepted

Insert into a table selecting data from a sub query

3 votes

Cleaning up specific domain logins on about 50 servers and therefore the users

3 votes
Accepted

Log file won't shrink - suggestions?

3 votes

How to find out which object is taking space?

3 votes

How does proportional fill algorithm help with tempdb performance once the files are full?

3 votes
Accepted

Key lookup still happening after creating covering index

2 votes

When is it ok to use an Index Hint on a query in production code?

2 votes
Accepted

Query to get data from 2 different tables is taking long time

2 votes

How to check AUTO_CREATE_STATISTICS/AUTO_UPDATE_STATISTICS is enabled for database

2 votes
Accepted

quotename(object_schema_name(@objectId)) returns null when called as a synonym

2 votes

Non Clustered Index using INCLUDE

2 votes

sql delete records based on combination of multiple fields in other table

2 votes
Accepted

alwayson read only routing