Skip to main content
jericzech's user avatar
jericzech's user avatar
jericzech's user avatar
jericzech
  • Member for 6 years, 8 months
  • Last seen more than a week ago
  • Brno, Česko
25 votes
3 answers
6k views

Why filtered index on IS NULL value is not used?

10 votes
1 answer
3k views

Unbelievably slow and unusable Query Store

6 votes
1 answer
275 views

Is Scalar UDF inlining broken?

5 votes
2 answers
282 views

How to get SEEK accessing converted ID via view

4 votes
1 answer
126 views

Mysterious conditional where clause index choices

4 votes
1 answer
822 views

No parallelism in Express Edition of SQL Server

3 votes
1 answer
182 views

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

3 votes
0 answers
2k views

SSMS 18.0 switching between tabs problem [closed]

2 votes
2 answers
1k views

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

2 votes
1 answer
1k views

How to rewrite CASE expression to short-circuit evaluation

2 votes
1 answer
190 views

Ideas how to make this query faster?

2 votes
3 answers
3k views

Filtered index is not used when variable in WHERE condition

2 votes
1 answer
730 views

Relation of PAGELATCH waits with PAGEIOLATCH and WRITELOG

2 votes
3 answers
625 views

Instant plan cache cleanup

2 votes
2 answers
2k views

Monitor source SQL code of inserts into table

2 votes
0 answers
119 views

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

2 votes
4 answers
698 views

Multi-insert batch executed remotely 5x slower than locally

2 votes
2 answers
927 views

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

2 votes
5 answers
2k views

CREATE Windows User in database for not existing domain

1 vote
0 answers
1k views

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

1 vote
1 answer
189 views

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

1 vote
2 answers
249 views

Decision concerning RAM limit

1 vote
0 answers
790 views

Database Mail with SSL (like GMAIL SMTP) not working

1 vote
1 answer
610 views

Deadlock on the same resource calling the same procedure

0 votes
2 answers
517 views

Should I believe Query Store runtime stats?

0 votes
1 answer
132 views

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

0 votes
1 answer
123 views

Does write stalls on separated MDF file affect performance

0 votes
1 answer
44 views

Rows to EAV structure with row identifier

0 votes
1 answer
67 views

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

0 votes
0 answers
39 views

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