New answers tagged sql-server-2014
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
Accepted
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 ...
- 101
Top 50 recent answers are included