User Forrest

6 votes

Accepted

deadlock with repeatable read isolation level

answered Jan 8, 2021 at 1:57

13 votes

Accepted

Cardinality estimate outside the histogram

answered Aug 13, 2019 at 19:08

34 votes

How to add 1 milliseconds to a datetime string?

answered Jul 23, 2019 at 14:07

5 votes

why it is doing index seek

answered May 22, 2019 at 14:07

10 votes

Does STATISTICS IO output include Version Store reads?

answered May 9, 2019 at 2:50

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

4 votes

Accepted

How can you have a Buffer cache hit ratio of 100% with PLE of 103?

answered Apr 18, 2019 at 16:40

6 votes

Collect SQL Server Query Execution time in seconds

answered Mar 21, 2019 at 11:56

1 vote

Disable a bad SQL Server Query Plan vs. Force a good plan

answered Mar 6, 2019 at 20:20

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

3 votes

Accepted

Excessive memory grants from indexed foreign key cascade delete

answered Feb 28, 2019 at 19:26

8 votes

Unbelievably slow and unusable Query Store

answered Feb 27, 2019 at 18:43

5 votes

Never ending Query Store search

answered Feb 27, 2019 at 14:19

9 votes

Accepted

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

answered Feb 26, 2019 at 14:34

4 votes

Accepted

Partitioning and Performance of DB Table

answered Feb 24, 2019 at 14:38

3 votes

Accepted

Columnstore index for Key/Value Pair table on SQL Server

answered Feb 7, 2019 at 16:04

7 votes

Accepted

Same query hash for totally different queries

answered Jan 23, 2019 at 15:14

10 votes

Accepted

Sort spills to tempdb due to varchar(max)

answered Jan 16, 2019 at 14:58

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

5 votes

Accepted

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

answered Dec 4, 2018 at 14:28

9 votes

Accepted

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

answered Nov 20, 2018 at 21:01

1 vote

Really Small details about storage ( data size ) on columns

answered Oct 18, 2018 at 15:55

2 votes

leaf_allocation_count in dm_db_index_operational_stats not changing on insert bulk

answered Oct 10, 2018 at 13:41

9 votes

Accepted

REORGANIZE INDEX blocks other queries

answered Sep 10, 2018 at 18:51

2 votes

sp_spaceused reveals 0 rows but 72 KB of reserved space

answered Sep 10, 2018 at 12:12

5 votes

Accepted

Forced serialization on inline table valued function

answered Sep 6, 2018 at 12:35

3 votes

Accepted

SQL job ignoring IF condition

answered Aug 30, 2018 at 12:16

6 votes

How to query against exact values in XML column set

answered Aug 21, 2018 at 15:10

10 votes

Accepted

Group together similar queries in sys.dm_exec_sql_text

answered Aug 7, 2018 at 13:17

2 votes

Does large VARCHAR take up more room in the transaction log

answered Jun 13, 2018 at 17:22

Stack Exchange Network

54 Answers

deadlock with repeatable read isolation level

Cardinality estimate outside the histogram

How to add 1 milliseconds to a datetime string?

why it is doing index seek

Does STATISTICS IO output include Version Store reads?

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

How can you have a Buffer cache hit ratio of 100% with PLE of 103?

Collect SQL Server Query Execution time in seconds

Disable a bad SQL Server Query Plan vs. Force a good plan

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

Excessive memory grants from indexed foreign key cascade delete

Unbelievably slow and unusable Query Store

Never ending Query Store search

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

Partitioning and Performance of DB Table

Columnstore index for Key/Value Pair table on SQL Server

Same query hash for totally different queries

Sort spills to tempdb due to varchar(max)

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

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

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

Really Small details about storage ( data size ) on columns

leaf_allocation_count in dm_db_index_operational_stats not changing on insert bulk

REORGANIZE INDEX blocks other queries

sp_spaceused reveals 0 rows but 72 KB of reserved space

Forced serialization on inline table valued function

SQL job ignoring IF condition

How to query against exact values in XML column set

Group together similar queries in sys.dm_exec_sql_text

Does large VARCHAR take up more room in the transaction log