Network profile

Vladimir Baranov

Reputation

4,395

4.4k
3.9k
3.5k

2018
2019
2020
2021

Top tag

sql-server

Next privilege

5,000 Rep.

Approve tag wiki edits

Badges

2

19

37

Newest

Notable Question

Next badge

0/1

Impact

12 posts edited

3 helpful flags

334 votes cast

13 Questions

Votes Activity Newest Views

7

18

votes

7

answers

3k

views

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

sql-server sql-server-2008 gaps-and-islands

Aug 14 '19 at 23:10 Marcello Miorelli 13.7k

6

17

votes

4

answers

8k

views

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

sql-server sql-server-2008

Sep 18 at 16:35 Solomon Rutzky 62.1k

4

15

votes

1

answer

8k

views

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

sql-server sql-server-2008 sql-server-2014

Jan 13 '17 at 6:13 Community♦ 1

2

8

votes

2

answers

2k

views

Increase a counter for each changed row

sql-server sql-server-2008

Nov 28 '17 at 10:50 Oreo 1,424

4

6

votes

1

answer

849

views

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

sql-server ssms

Jul 26 '18 at 9:32 David 1

5

votes

1

answer

3k

views

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

sql-server sql-server-2016 temporal-tables

Jun 19 '17 at 20:45 Martin Smith 75.4k

5

votes

2

answers

7k

views

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

sql-server sql-server-2008 t-sql locking

Sep 2 '15 at 5:57 Community♦ 1

1

vote

1

answer

36

views

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

sql-server execution-plan linked-server

Apr 7 at 11:59 J.D. 14k

1

vote

2

answers

59

views

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

sql-server sql-server-2012 query-performance execution-plan

Mar 19 at 12:21 Vladimir Baranov 4,395

1

vote

1

answer

63

views

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

sql-server linked-server

Mar 18 at 12:18 Vladimir Baranov 4,395

0

votes

1

answer

253

views

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

sql-server sql-server-2012 query-performance sql-server-2016 linked-server

Feb 15 at 14:32 J.D. 14k

0

votes

2

answers

50

views

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

sql-server sql-server-2016 transaction-log shrink

Feb 15 at 11:32 Shanky 17.5k

1

0

votes

1

answer

2k

views

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

sql-server sql-server-2008

Mar 16 '16 at 3:42 Community♦ 1

Database Administrators Stack Exchange works best with JavaScript enabled