20 May

Best Practice No.5

Keep VLF Count in check for all your transaction log files. Too many VLFs can cause slow DB Recovery & performance Hit.

16 May

Best Practice No.4

Use Set NOCOUNT ON for all Batches, Stored Procedures and Triggers to reduce Network traffic for SQL Server.

12 May

Best Practice No.3

Grant Granular access whenever possible to avoid providing elevated access.

10 May

Best Practice No-2

The KEEP PLAN query hint changes the recompilation thresholds for temporary tables, and makes them identical to those for permanent tables. Therefore, if changes to temporary tables are causing many recompilations, this query hint can be used.

9 May

Best Practice No.1

Disable xp_cmdshell unless it is absolutely required.