New answers tagged

0 votes

Clearing plan cache improves performance - bad plans in cache?

Plans stay in cache until forced out by memory pressure, statistics updates at a certain level, or you recompile them. If a plan gets compiled for a value that returns say 1 record, then, later, gets ...
1 vote

Where to find documentation about the log reader procedures?

I am struggling to find any documentation on the stored procedure that I use to find out what the log reader agent has been doing: sp_MSenum_logreader_sd Have you looked at the output of sp_helptext '...
0 votes

how to disable encryption on SQL server 2014 connection that SSL is enforced by windows

Not a fan of Windows, and just needed to get the database out from a backup file. Did not want to worry about SSL certificates etc. If you are not doing on this production, there is an easy way around ...

Top 50 recent answers are included