User Forrest

33 votes

How to add 1 milliseconds to a datetime string?

answered Jul 23, 2019 at 14:07

17 votes

Accepted

Does ALTER INDEX ALL REBUILD use more transaction log space with simple recovery model than rebuilding each index individually?

answered Jul 10, 2017 at 20:43

13 votes

Accepted

Cardinality estimate outside the histogram

answered Aug 13, 2019 at 19:08

10 votes

Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode

answered Apr 18, 2019 at 21:37

10 votes

Does STATISTICS IO output include Version Store reads?

answered May 9, 2019 at 2:50

10 votes

Accepted

Group together similar queries in sys.dm_exec_sql_text

answered Aug 7, 2018 at 13:17

10 votes

Accepted

Sort spills to tempdb due to varchar(max)

answered Jan 16, 2019 at 14:58

9 votes

Accepted

Why would optimiser choose Clustered Index + Sort instead of Non-Clustered Index?

answered Nov 20, 2018 at 21:01

8 votes

Accepted

Mysterious conditional where clause index choices

answered Dec 15, 2017 at 19:38

8 votes

Accepted

Why would a Clustered Index Seek return a higher "Actual Number of Rows" than there are rows in the underlying table?

answered Dec 12, 2018 at 16:41

8 votes

Accepted

Updating Statistics: Estimated Number of Rows not equal to Actual for Index Scan. Why?

answered Feb 26, 2019 at 14:34

7 votes

T-SQL dynamically import XML into tables (SQL Server 2014)

answered Sep 11, 2017 at 15:19

7 votes

Accepted

Same query hash for totally different queries

answered Jan 23, 2019 at 15:14

6 votes

Unbelievably slow and unusable Query Store

answered Feb 27, 2019 at 18:43

6 votes

Collect SQL Server Query Execution time in seconds

answered Mar 21, 2019 at 11:56

5 votes

why it is doing index seek

answered May 22, 2019 at 14:07

5 votes

Accepted

deadlock with repeatable read isolation level

answered Jan 8, 2021 at 1:57

5 votes

Accepted

What is the impact on the Cost-Based Optimizer (CBO) when implementing ISCSI SAN solid-state drives

answered Mar 6, 2019 at 19:47

5 votes

Never ending Query Store search

answered Feb 27, 2019 at 14:19

5 votes

Accepted

Parameter sniffing = On with Parameterization = forced. Which takes precedence?

answered Dec 4, 2018 at 14:28

5 votes

Accepted

Forced serialization on inline table valued function

answered Sep 6, 2018 at 12:35

5 votes

Accepted

REORGANIZE INDEX blocks other queries

answered Sep 10, 2018 at 18:51

5 votes

How to query against exact values in XML column set

answered Aug 21, 2018 at 15:10

5 votes

Accepted

Locked out of an old 2008R2 Database

answered Jan 17, 2018 at 20:15

5 votes

Accepted

Is B-Tree re-balanced during deletion of data from SQL Server table with a clustered index?

answered Apr 20, 2018 at 13:48

5 votes

Accepted

Return number of rows based on column value

answered Dec 29, 2016 at 17:06

5 votes

Accepted

What are the three parts of a LSN?

answered Jun 1, 2017 at 16:45

5 votes

SQL Server 2016 - Parameter Sniffing Turned Off - Still seeing where a recompile improves performance

answered Jun 9, 2017 at 19:09

4 votes

Does SQL Server log record uncommited operations?

answered Jun 7, 2017 at 15:38

4 votes

Rounding Down with ROUND() function

answered Sep 20, 2016 at 17:25

Stack Exchange Network

54 Answers

How to add 1 milliseconds to a datetime string?

Does ALTER INDEX ALL REBUILD use more transaction log space with simple recovery model than rebuilding each index individually?

Cardinality estimate outside the histogram

Converted a Scalar function to a TVF function for parallel execution-Still running in Serial mode

Does STATISTICS IO output include Version Store reads?

Group together similar queries in sys.dm_exec_sql_text

Sort spills to tempdb due to varchar(max)

Why would optimiser choose Clustered Index + Sort instead of Non-Clustered Index?

Mysterious conditional where clause index choices

Why would a Clustered Index Seek return a higher "Actual Number of Rows" than there are rows in the underlying table?

Updating Statistics: Estimated Number of Rows not equal to Actual for Index Scan. Why?

T-SQL dynamically import XML into tables (SQL Server 2014)

Same query hash for totally different queries

Unbelievably slow and unusable Query Store

Collect SQL Server Query Execution time in seconds

why it is doing index seek

deadlock with repeatable read isolation level

What is the impact on the Cost-Based Optimizer (CBO) when implementing ISCSI SAN solid-state drives

Never ending Query Store search

Parameter sniffing = On with Parameterization = forced. Which takes precedence?

Forced serialization on inline table valued function

REORGANIZE INDEX blocks other queries

How to query against exact values in XML column set

Locked out of an old 2008R2 Database

Is B-Tree re-balanced during deletion of data from SQL Server table with a clustered index?

Return number of rows based on column value

What are the three parts of a LSN?

SQL Server 2016 - Parameter Sniffing Turned Off - Still seeing where a recompile improves performance

Does SQL Server log record uncommited operations?

Rounding Down with ROUND() function