Serdia's user avatar
Serdia's user avatar
Serdia's user avatar
Serdia
  • Member for 6 years, 7 months
  • Last seen more than a month ago
26 votes
3 answers
44k views

Eliminate Key Lookup (Clustered) operator that slows down performance

4 votes
3 answers
679 views

Is it possible to build Data warehouse by myself?

3 votes
1 answer
266 views

Is it possible to see blocker's host name or machine name using sp_WhoIsActive?

3 votes
1 answer
711 views

What Microsoft DBA certificate should I acquire?

3 votes
1 answer
335 views

Why putting SQL Agent offline caused WSFC to fail over on passive node?

2 votes
4 answers
7k views

why computed columns slowing down performance all the sudden?

2 votes
0 answers
57 views

Tempdb. There is no enough space on the disc encountered

1 vote
2 answers
819 views

This differential backup cannot be restored because the database has not been restored to the correct earlier state

1 vote
1 answer
98 views

Should I partition a database file for performance improvement if a file sits on RAID?

1 vote
1 answer
186 views

Unable to shrink data file with LOB data sql server 2017

1 vote
1 answer
228 views

Why sql service is still running after uninstalling failover cluster instance?

0 votes
1 answer
309 views

Certificate (SHA1) loaded in a database but couldn't be found under SQL Configuration Manager and Key Registry

0 votes
1 answer
266 views

extract values from different stored procedures and create one report

0 votes
1 answer
662 views

How to display name on a column chart itself in SSRS, not on a legends

0 votes
2 answers
326 views

What is the best way to keep track of all changes implemented on a database? [closed]

0 votes
1 answer
2k views

How to trace steps in SQL profiler for only particular application

0 votes
0 answers
34 views

UI freezes when at the particular task and only when accessing from terminal machine

0 votes
1 answer
169 views

How to query database integrity check duration time (how much time did it take to complete dbcc checkdb) [duplicate]

0 votes
1 answer
251 views

Speeding up DBCC CHECKDB on a large database

0 votes
1 answer
60 views

Can Availability Group be configured in a below structure?

0 votes
2 answers
63 views

How to know how healthy an SQL Server database is now?

0 votes
0 answers
68 views

Report server (SSRS) email delivery delayed for 10 hours

0 votes
1 answer
65 views

How to configure Always ON High Availability on this infrastructure?

0 votes
2 answers
480 views

Testing WSFC failover puts secondary replica in RESOLVING mode

0 votes
1 answer
98 views

Should I change parallelism (MaxDop and Threshold)?

-1 votes
1 answer
64 views

Should my company upgrade from Enterprise 2017 to sql server 2019? [closed]