User jericzech

25 votes

2 answers

6k views

Why filtered index on IS NULL value is not used?

asked Sep 7, 2018 at 18:13

10 votes

1 answer

3k views

Unbelievably slow and unusable Query Store

asked May 31, 2018 at 18:15

6 votes

1 answer

257 views

Is Scalar UDF inlining broken?

asked Feb 6, 2020 at 14:57

5 votes

2 answers

274 views

How to get SEEK accessing converted ID via view

asked Apr 29, 2019 at 16:22

4 votes

1 answer

126 views

Mysterious conditional where clause index choices

asked Dec 15, 2017 at 15:58

4 votes

1 answer

716 views

No parallelism in Express Edition of SQL Server

asked Apr 16, 2021 at 9:55

3 votes

1 answer

173 views

sp_HumanEvents @event_type = N'blocking' and logging job help needed

asked Sep 9, 2021 at 13:08

3 votes

0 answers

1k views

SSMS 18.0 switching between tabs problem [closed]

asked May 14, 2019 at 18:54

2 votes

2 answers

882 views

DBCC FREESYSTEMCACHE(‘SQL Plans’) deletes all ad-hoc and prepared plans, not just single-used ones

asked Jun 21, 2019 at 15:55

2 votes

1 answer

1k views

How to rewrite CASE expression to short-circuit evaluation

asked Oct 10, 2019 at 17:19

2 votes

1 answer

189 views

Ideas how to make this query faster?

asked Oct 26, 2017 at 19:26

2 votes

3 answers

2k views

Filtered index is not used when variable in WHERE condition

asked Oct 16, 2019 at 20:31

2 votes

1 answer

687 views

Relation of PAGELATCH waits with PAGEIOLATCH and WRITELOG

asked Jan 22, 2018 at 10:39

2 votes

3 answers

552 views

Instant plan cache cleanup

asked Jun 29, 2018 at 14:40

2 votes

2 answers

1k views

Monitor source SQL code of inserts into table

asked Sep 15, 2018 at 9:34

2 votes

0 answers

111 views

Source (eg.statement) associated with security memory cache entry (USERSTORE_TOKENPERM / TokenAndPermUserStore)

asked Jun 23, 2021 at 14:12

2 votes

4 answers

631 views

Multi-insert batch executed remotely 5x slower than locally

asked Nov 28, 2020 at 11:42

2 votes

2 answers

769 views

Index strategy for TEXT / NTEXT column to filter out NULL / NOT NULL rows

asked Feb 3, 2021 at 8:13

2 votes

5 answers

2k views

CREATE Windows User in database for not existing domain

asked Feb 4, 2021 at 11:51

1 vote

0 answers

1k views

Could not obtain information about Windows NT group/user, error code 0x6ba

asked May 20, 2021 at 9:45

1 vote

1 answer

183 views

Does logical reads in RAM appears in wait stats or where?

asked Aug 15, 2018 at 18:43

1 vote

2 answers

227 views

Decision concerning RAM limit

asked Mar 15, 2018 at 14:50

1 vote

0 answers

749 views

Database Mail with SSL (like GMAIL SMTP) not working

asked Oct 16, 2019 at 12:30

1 vote

1 answer

544 views

Deadlock on the same resource calling the same procedure

asked Jun 5, 2019 at 21:26

0 votes

2 answers

470 views

Should I believe Query Store runtime stats?

asked Sep 3, 2019 at 20:13

0 votes

1 answer

130 views

DB server VM's CPU configuration - 1x2Ghz or 2x1Ghz - which is better

asked Nov 14, 2018 at 14:39

0 votes

1 answer

120 views

Does write stalls on separated MDF file affect performance

asked Feb 26, 2019 at 16:46

0 votes

1 answer

43 views

Rows to EAV structure with row identifier

asked Feb 10, 2020 at 23:27

0 votes

1 answer

67 views

Repairing buggy query server-side – without changes in the app

asked Mar 31, 2021 at 8:34

0 votes

0 answers

39 views

sp_WhoIsActive CREATE statement in sql_text column while executing object inside another [duplicate]

asked Sep 16, 2021 at 11:03

Stack Exchange Network

31 Questions

Why filtered index on IS NULL value is not used?

Unbelievably slow and unusable Query Store

Is Scalar UDF inlining broken?

How to get SEEK accessing converted ID via view

Mysterious conditional where clause index choices

No parallelism in Express Edition of SQL Server

sp_HumanEvents @event_type = N'blocking' and logging job help needed

SSMS 18.0 switching between tabs problem [closed]

DBCC FREESYSTEMCACHE(‘SQL Plans’) deletes all ad-hoc and prepared plans, not just single-used ones

How to rewrite CASE expression to short-circuit evaluation

Ideas how to make this query faster?

Filtered index is not used when variable in WHERE condition

Relation of PAGELATCH waits with PAGEIOLATCH and WRITELOG

Instant plan cache cleanup

Monitor source SQL code of inserts into table

Source (eg.statement) associated with security memory cache entry (USERSTORE_TOKENPERM / TokenAndPermUserStore)

Multi-insert batch executed remotely 5x slower than locally

Index strategy for TEXT / NTEXT column to filter out NULL / NOT NULL rows

CREATE Windows User in database for not existing domain

Could not obtain information about Windows NT group/user, error code 0x6ba

Does logical reads in RAM appears in wait stats or where?

Decision concerning RAM limit

Database Mail with SSL (like GMAIL SMTP) not working

Deadlock on the same resource calling the same procedure

Should I believe Query Store runtime stats?

DB server VM's CPU configuration - 1x2Ghz or 2x1Ghz - which is better

Does write stalls on separated MDF file affect performance

Rows to EAV structure with row identifier

Repairing buggy query server-side – without changes in the app

sp_WhoIsActive CREATE statement in sql_text column while executing object inside another [duplicate]