Skip to main content
Share Your Experience: Take the 2024 Developer Survey
Vladimir Baranov's user avatar
Vladimir Baranov's user avatar
Vladimir Baranov's user avatar
Vladimir Baranov
  • Member for 9 years, 4 months
  • Last seen this week
  • Melbourne
19 votes
4 answers
11k views

In what cases a transaction can be committed from inside the CATCH block when XACT_ABORT is set to ON?

18 votes
7 answers
4k views

Group daily schedule into [Start date; End date] intervals with the list of week days

17 votes
1 answer
16k views

ROW_NUMBER() OVER (PARTITION BY B,A ORDER BY C) doesn't use index on (A,B,C)

8 votes
2 answers
4k views

Increase a counter for each changed row

6 votes
1 answer
1k views

SSMS suddenly starts generating DEFAULT constraints inlined into the CREATE TABLE statements instead of ALTER TABLE

6 votes
2 answers
8k views

Using sp_getapplock to implement a queue. Is it correct? Is there a better way?

5 votes
1 answer
3k views

Will Temporal Tables be included in the Standard Edition of SQL Server 2016?

5 votes
3 answers
571 views

Can Postgres scan indexes backwards?

2 votes
2 answers
776 views

How to hint Remote Scan operator to estimate more than 10000 rows?

1 vote
1 answer
577 views

How to get an actual execution plan from the linked server?

1 vote
1 answer
3k views

Some users fail to query linked server with "Login failed for user NT AUTHORITY\ANONYMOUS LOGON"

1 vote
1 answer
8k views

Cannot fetch a row from OLE DB provider "SQLNCLI11" for linked server

0 votes
2 answers
111 views

What could be the reason for shrinking the transaction log file before and after the database backup?

0 votes
1 answer
3k views

A login is a member of db_datareader and public roles only, but it is not read-only