Showing posts from March, 2020

Essential Trace Flags to enable at SQL Server Services startup

 List of trace flags to enable on SQL server service startup: Server Name Trace Flag Status Global Session PRD-MSSQL01C 1222 1 1 0 PRD-MSSQL01C 1224 1 1 0 PRD-MSSQL01C 4136 1 1 0 Reason:  4136  will help in preventing parameter sniffing on sql server and in turn will result in query optimizer to create optimized plans for same queries having different parameters which will result in better performance.  Note: Please ensure that you thoroughly test this option, before rolling it into a production environment. Scope: Global or session 1224 d isables lock escalation based on the number of locks. However, memory pressure can still activate lock escalation. This helps avoid "out-of-locks" errors when many locks are being used. Scope:  Global or session 1222 helps in detecting deadlocks r eturns the resources and types of locks that are participating in a deadlock and also the current command affected, in an XML format that does not comply with any XSD schema. Not

Checklist: Before applying for adsense

Before applying for adsense below things has to be taken care of Remove reference to all other old sites and turn of profile about widgets Create a email Create a google analytics account link it to your site Create a menu structure Fill ALT and Description tags for all posts and images No follow external links Place menu optimally and check its working fine and visible in all screen sizes See available adsence widgets still has proper visibility after template modifications Correct all grammatical mistakes Create About, Contact and Privacy pages Create few more Posts Work on SEO a bit for few days Add links to Youtube channel