user avatar
user avatar
user avatar
jericzech
  • Member for 4 years, 8 months
  • Last seen this week
  • Brno, Česko
25 votes
2 answers
5k views

Why filtered index on IS NULL value is not used?

10 votes
1 answer
2k views

Unbelievably slow and unusable Query Store

6 votes
1 answer
153 views

Is Scalar UDF inlining broken?

5 votes
2 answers
262 views

How to get SEEK accessing converted ID via view

4 votes
1 answer
115 views

Mysterious conditional where clause index choices

4 votes
1 answer
415 views

No parallelism in Express Edition of SQL Server

3 votes
1 answer
117 views

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

3 votes
0 answers
1k views

SSMS 18.0 switching between tabs problem [closed]

2 votes
2 answers
397 views

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

2 votes
1 answer
572 views

How to rewrite CASE expression to short-circuit evaluation

2 votes
1 answer
599 views

Relation of PAGELATCH waits with PAGEIOLATCH and WRITELOG

2 votes
3 answers
453 views

Instant plan cache cleanup

2 votes
2 answers
896 views

Monitor source SQL code of inserts into table

2 votes
1 answer
187 views

Ideas how to make this query faster?

2 votes
0 answers
86 views

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

2 votes
4 answers
221 views

Multi-insert batch executed remotely 5x slower than locally

2 votes
2 answers
218 views

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

2 votes
5 answers
539 views

CREATE Windows User in database for not existing domain

1 vote
0 answers
410 views

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

1 vote
1 answer
126 views

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

1 vote
2 answers
169 views

Decision concerning RAM limit

1 vote
0 answers
511 views

Database Mail with SSL (like GMAIL SMTP) not working

1 vote
3 answers
1k views

Filtered index is not used when variable in WHERE condition

1 vote
1 answer
169 views

Deadlock on the same resource calling the same procedure

0 votes
2 answers
372 views

Should I believe Query Store runtime stats?

0 votes
1 answer
36 views

Rows to EAV structure with row identifier

0 votes
1 answer
127 views

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

0 votes
1 answer
64 views

Does write stalls on separated MDF file affect performance

0 votes
1 answer
53 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]