Fza's user avatar
Fza's user avatar
Fza's user avatar
Fza
  • Member for 6 years, 2 months
  • Last seen this week
24 votes
2 answers
2k views

Cardinality Estimate for LIKE operator (Local Variables)

5 votes
3 answers
437 views

Quickest Method To Invalidate Statistics

4 votes
1 answer
3k views

SQL Server 2016 - excessive memory grant warning on poor performing query

4 votes
2 answers
1k views

SQL Server expensive nested loops join and lazy table spool

3 votes
2 answers
35k views

T-SQL query for date of last full backup, size and location

3 votes
1 answer
540 views

Methods to identify/recognise 'bad' parameter sniffing in SQL Server

2 votes
1 answer
2k views

AlwaysON AG synchronous commit mode disconnected transaction log effect and mitigation

2 votes
1 answer
103 views

SQL Server - Do automatically created column statistics get dropped automatically after time?

2 votes
3 answers
446 views

SQL Server 2017 Stored Proc & TVF Performance Problem

2 votes
1 answer
657 views

What locks are taken during statistic operations in SQL Server?

1 vote
1 answer
142 views

Shredding Query Plan XML For Potential Skewed Estimates - Data Type Conversions

1 vote
1 answer
2k views

AlwaysON Availability Groups - IP address change of secondary replica node

1 vote
1 answer
4k views

AlwaysON Availability Groups - IP address & subnet change of secondary replica node