User David Browne - Microsoft - Database Administrators Stack Exchange

David Browne - Microsoft

Member for 5 years, 9 months
Last seen this week

blogs.msdn.microsoft.com/…
Dallas, TX, United States

1,151 Answers

Score Activity Newest

82 votes

Accepted

What does the GO statement do in SQL Server?

answered Jan 11, 2021 at 22:51

57 votes

Accepted

Is it generally faster to select into a temp table than selecting into an actual table?

answered Jan 23, 2020 at 1:13

37 votes

What's a good use case for SELECT * in production code?

answered Nov 22, 2019 at 1:31

29 votes

Accepted

Why filtered index on IS NULL value is not used?

answered Sep 7, 2018 at 18:31

28 votes

Accepted

SQL Server - Select most recent record from each group when performance is critical

answered Feb 4, 2020 at 19:43

25 votes

10 TB database backup / restore Question

answered May 9, 2018 at 13:57

23 votes

Does SQL Server support GREATEST and LEAST, if not what is the common workaround?

answered Sep 27, 2017 at 22:10

23 votes

Accepted

Seemingly identical WHERE clauses returning different results

answered Sep 10, 2021 at 23:14

22 votes

Accepted

What is a SQL Server "GDR"?

answered Dec 24, 2017 at 0:13

20 votes

Accepted

Is it possible for SQL statements to execute concurrently within a single session in SQL Server?

answered Apr 18, 2019 at 22:02

20 votes

Is there any (hidden) built-in function on MS-SQL to unquote object names?

answered Jan 22, 2018 at 16:55

19 votes

Best way to put commas into large numbers

answered Sep 5, 2018 at 18:04

19 votes

SQL Server Instance How to recover memory used

answered Mar 22, 2021 at 14:37

18 votes

Accepted

How to inspect global temp table from outside the transaction it is created in

answered Jan 31, 2019 at 20:39

18 votes

Accepted

Is the NOLOCK hint completely safe to use on a table that's guaranteed not to change?

answered Nov 4, 2019 at 18:43

16 votes

Accepted

Safe to use WITH (NOLOCK) in this case?

answered Dec 14, 2020 at 22:10

15 votes

How do I limit a SQL stored procedure to be run by one person at a time?

answered Oct 5, 2018 at 12:55

15 votes

Are the limits of varchar(8000) and nvarchar(4000) because of the sql server page size (8KB=8192 Bytes)?

answered Feb 21, 2022 at 14:11

14 votes

Accepted

Windows OS Quantum vs. SQL OS Quantum

answered May 9, 2019 at 16:07

14 votes

What is the appropriate index architecture when forced to implement IsDeleted (soft deletes)?

answered Apr 18, 2019 at 14:48

14 votes

Is there any way I can speed up this large full-table query?

answered Jun 3, 2020 at 19:31

13 votes

Accepted

Can a stored procedure reference the database in which it is stored?

answered Apr 25, 2019 at 14:21

13 votes

RAID0 instead of RAID1 or 5, is this crazy?

answered Aug 28, 2019 at 16:58

13 votes

Accepted

Solving intra parallel query deadlocks

answered Aug 28, 2018 at 20:53

13 votes

What happens when you change a heap into a clustered table in SQL Server?

answered Apr 12, 2021 at 2:58

13 votes

Accepted

SQL Server Logon Trigger Implications - are there any side effects possible in my scenario?

answered May 3, 2021 at 17:10

13 votes

Accepted

Should stored financial transactions include some data redundancy?

answered Jun 17, 2021 at 19:34

12 votes

Accepted

Infinite loop in CURSOR

answered Aug 19, 2019 at 16:39

12 votes

Where can I find documentation on SQL Server internals?

answered Dec 13, 2017 at 15:10

12 votes

Create table permission for a user in specific schema

answered Jun 26, 2017 at 22:29

1

2 3 4 5

…