User BVernon - Database Administrators Stack Exchange

BVernon

Member for 9 years, 7 months
Last seen more than a week ago

Plano, TX, USA

Network profile

19 Questions

Score Activity Newest Views

8 votes

3 answers

15k views

Update statements with set transaction isolation level read uncommitted

asked Aug 23, 2016 at 16:49

5 votes

1 answer

110 views

Okay to merge included columns on otherwise identical indexes?

asked Apr 16, 2019 at 22:54

4 votes

3 answers

492 views

Can adding both Asc and Desc indexes improve performance?

asked Aug 18, 2016 at 18:47

4 votes

1 answer

339 views

Why would you give a database user a different name than the sql login it's mapped to?

asked Oct 6, 2021 at 21:13

2 votes

1 answer

243 views

Does SQL Server support restoring to a point in time down to the millisecond?

asked Aug 27, 2013 at 18:08

1 vote

1 answer

3k views

Does the recovery model affect query speed?

asked Dec 19, 2013 at 17:58

1 vote

1 answer

2k views

Snapshot agent stuck at 48%

asked Mar 11, 2014 at 15:42

1 vote

2 answers

5k views

How to drop database that I can't get out of single user mode?

asked Apr 2, 2014 at 22:41

1 vote

1 answer

103 views

Do existing connections immediately honor a change to the TRUSTWORTHY setting?

asked Dec 14, 2021 at 1:03

1 vote

0 answers

78 views

Restoring a database to a point in time: Database I want not showing up in dropdown list

asked Aug 25, 2013 at 19:27

1 vote

1 answer

45 views

Will this RedGate backup plan interfere with a new differential backup plan I want to create?

asked May 14, 2019 at 4:22

0 votes

1 answer

49 views

Possible to do OPENQUERY without named pipes?

asked Apr 22, 2020 at 23:21

0 votes

1 answer

998 views

Designing a table with foreign keys to multiple "parent" tables

asked Oct 7, 2021 at 5:58

0 votes

1 answer

47 views

Finding a balance with normalization and when to keep similar data together

asked Oct 17, 2021 at 1:18

0 votes

1 answer

1k views

Restoring to specific point in time in SQL Server

asked Nov 27, 2013 at 19:17

0 votes

1 answer

732 views

When is dm_exec_procedure_stats updated? [duplicate]

asked Dec 14, 2016 at 22:23

0 votes

1 answer

83 views

How to better manage hard coded cross db references in stored procs?

asked Oct 30, 2017 at 2:36

0 votes

2 answers

721 views

Possible to tell what a query was in session I just killed?

asked Nov 20, 2017 at 22:37

0 votes

1 answer

30 views

Documenting where stored procs are called from [closed]

asked Aug 11, 2018 at 20:35