SQL Tip-6 | Use Covering Index to solve key lookup issues
Do you have Key Lookup problem? Key lookup taking most of the query time. then probably this is the best
Read moresql tips
SQL Tip-3 | Don’t Shrink your Database
You should avoid shrinking your database until and unless it becomes unmanageable. Shrinking is a Resource intensive task, Moreover it
Read moreSQL Tip-2 | Make Sure the startup type of your SQL Service is Automatic*
I know this one is very basic but in the recent past I noticed a couple of environments where the
Read moreSQL Tip-1 | Don’t forget to recycle your SQLServer ErrorLog
Many a times I’ve seen that DBAs forget to recycle the ErrorLog of their critical SQLServers. Now I also understand
Read more