jericzech's user avatar
jericzech's user avatar
jericzech's user avatar
jericzech
  • Member for 6 years, 4 months
  • Last seen this week
  • 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
268 views

Is Scalar UDF inlining broken?

5 votes
2 answers
276 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
769 views

No parallelism in Express Edition of SQL Server

3 votes
1 answer
176 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
954 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
189 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
706 views

Relation of PAGELATCH waits with PAGEIOLATCH and WRITELOG

2 votes
3 answers
592 views

Instant plan cache cleanup

2 votes
2 answers
1k views

Monitor source SQL code of inserts into table

2 votes
0 answers
115 views

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

2 votes
4 answers
656 views

Multi-insert batch executed remotely 5x slower than locally

2 votes
2 answers
821 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
187 views

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

1 vote
2 answers
239 views

Decision concerning RAM limit

1 vote
0 answers
767 views

Database Mail with SSL (like GMAIL SMTP) not working

1 vote
1 answer
576 views

Deadlock on the same resource calling the same procedure

0 votes
2 answers
479 views

Should I believe Query Store runtime stats?

0 votes
1 answer
130 views

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

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