SQL Tips for junior

If the topic(s) you are looking for is not listed below, do leave a quick comment with the list of topics.

SQL Tip No. Topic
1 Don’t forget to recycle your SQLServer ErrorLog
2 Make Sure the startup type of your SQL Service is Automatic*
3 Don’t Shrink your Database
4 Do you know you can increase number of archived Errorlogs
5 Lightning Fast way to find errors in SQL Server Error Logs
6 Use Covering Index to solve key lookup issues
7 Different ways to enable a Trace Flag
8 How to script out multiple SQL Server jobs at once
9 Track the Original Login–even if the Execution Context is switched
10

 

Leave a Reply