User Dan Guzman

34 votes

Accepted

datetime2(0) vs datetime2(2)

answered Jan 11, 2017 at 12:19

32 votes

Accepted

Is this an error in SQL Server's documentation for ROLLBACK?

answered Apr 11, 2021 at 10:13

29 votes

Accepted

Why these characters are all equal in SQL Server?

answered May 6, 2015 at 12:01

27 votes

Accepted

Please explain what does "for xml path(''), TYPE) .value('.', 'NVARCHAR(MAX)')" do in this code

answered May 21, 2018 at 11:34

25 votes

Accepted

Disconnect from network without stopping the query

answered Aug 12, 2020 at 11:35

24 votes

Accepted

Best situation to use READ UNCOMMITTED isolation level

answered May 11, 2018 at 13:27

21 votes

ALTER VIEW drops Index from View

answered Feb 29, 2020 at 16:15

20 votes

SQL server DB status runnable, sleeping, suspended, running and background meanings

answered Jun 30, 2018 at 9:37

20 votes

Accepted

Is OPTION (RECOMPILE) used in production environments?

answered Apr 21, 2021 at 15:53

19 votes

In SQL Server, why can a backward scan of clustered index cannot not use parallelism?

answered Aug 11, 2019 at 13:33

16 votes

Accepted

What Happens to dirty pages if the system fails before the next checkpoint?

answered Aug 19, 2018 at 23:14

16 votes

Accepted

Moving SQL Server database to a new disk while online

answered Dec 15, 2015 at 12:56

15 votes

Accepted

Use "LEN" function in "WHERE" clause in "CREATE UNIQUE INDEX"

answered Jan 10, 2017 at 10:54

14 votes

Accepted

The use of multiple foreign keys on same column in SQL Server

answered Apr 6, 2019 at 14:27

13 votes

Even after Disabling Read-Ahead and clearing buffer , why there is Logical Read?

answered Jul 11, 2018 at 10:49

13 votes

Accepted

Size Requirement of SQL Database

answered Feb 24, 2021 at 12:23

13 votes

Accepted

Building an execution plan takes too long on SQL Server

answered Nov 9, 2020 at 16:02

13 votes

Accepted

Bug in Rebuild on SQL Server 2016 and above?

answered Jul 29, 2017 at 19:56

13 votes

Accepted

Why can SELECT see updated row before commit?

answered Oct 7, 2017 at 14:23

12 votes

Accepted

Fix corrupted utf8 nvarchar value that was inserted without N prefix

answered Oct 20, 2022 at 10:20

12 votes

Accepted

Why the sudden increase of my database .mdf file size?

answered Oct 22, 2020 at 11:08

12 votes

Accepted

Error starting localDb on Windows 11

answered Dec 11, 2021 at 13:37

12 votes

Why set Auto Update Statistics to False?

answered May 4, 2016 at 11:04

12 votes

Accepted

Why is TOP operation in SQL execution plan

answered Nov 1, 2015 at 16:28

11 votes

Is the data exchange on connection from client to server sent as plain text over the wire?

answered Jan 15, 2022 at 16:28

11 votes

Accepted

Divide, round and replace in one select statement - tranformation from bytes to GB in SQL Server

answered Aug 31, 2020 at 12:14

11 votes

Accepted

Missing rows under read committed isolation

answered Feb 15, 2021 at 13:53

11 votes

Accepted

What is the proper event in Extended Events to track stored procedure executions?

answered Jun 10, 2019 at 10:42

11 votes

Accepted

Deleting millions of records on SQL Server 14.0

answered Sep 3, 2019 at 10:44

11 votes

Accepted

sqlcmd -b doesn't exit on error

answered Mar 22, 2015 at 12:52

Stack Exchange Network

544 Answers

datetime2(0) vs datetime2(2)

Is this an error in SQL Server's documentation for ROLLBACK?

Why these characters are all equal in SQL Server?

Please explain what does "for xml path(''), TYPE) .value('.', 'NVARCHAR(MAX)')" do in this code

Disconnect from network without stopping the query

Best situation to use READ UNCOMMITTED isolation level

ALTER VIEW drops Index from View

SQL server DB status runnable, sleeping, suspended, running and background meanings

Is OPTION (RECOMPILE) used in production environments?

In SQL Server, why can a backward scan of clustered index cannot not use parallelism?

What Happens to dirty pages if the system fails before the next checkpoint?

Moving SQL Server database to a new disk while online

Use "LEN" function in "WHERE" clause in "CREATE UNIQUE INDEX"

The use of multiple foreign keys on same column in SQL Server

Even after Disabling Read-Ahead and clearing buffer , why there is Logical Read?

Size Requirement of SQL Database

Building an execution plan takes too long on SQL Server

Bug in Rebuild on SQL Server 2016 and above?

Why can SELECT see updated row before commit?

Fix corrupted utf8 nvarchar value that was inserted without N prefix

Why the sudden increase of my database .mdf file size?

Error starting localDb on Windows 11

Why set Auto Update Statistics to False?

Why is TOP operation in SQL execution plan

Is the data exchange on connection from client to server sent as plain text over the wire?

Divide, round and replace in one select statement - tranformation from bytes to GB in SQL Server

Missing rows under read committed isolation

What is the proper event in Extended Events to track stored procedure executions?

Deleting millions of records on SQL Server 14.0

sqlcmd -b doesn't exit on error