Best Practice No.8
Make sure Auto_Close is disabled for all Databases on your Production Servers.
Read moreData platform insights by Sarabpreet Singh Anand
Make sure Auto_Close is disabled for all Databases on your Production Servers.
Read moreMake sure you configure SQL Server to run on a NON Default port.
Read moreKeep Backup and Database files on separate disk to avoid single point of failure.
Read moreKeep VLF Count in check for all your transaction log files. Too many VLFs can cause slow DB Recovery &
Read moreUse Set NOCOUNT ON for all Batches, Stored Procedures and Triggers to reduce Network traffic for SQL Server.
Read moreGrant Granular access whenever possible to avoid providing elevated access.
Read moreThe KEEP PLAN query hint changes the recompilation thresholds for temporary tables, and makes them identical to those for permanent
Read moreDisable xp_cmdshell unless it is absolutely required.
Read moreIn first part we discussed, what is Execution Context, different types of Tokens available and what all information goes into
Read moreExecution context is maintained by the login that is connected or executing the query, then it checks the permissions of
Read more