SQL Mail Configuration Errors
You may be configuring SQL Mail for the first time or the thousandth time and you come across the following cryptic message. Date 8/xxxxxx03 AM… Read More »SQL Mail Configuration Errors
SQL Server
Largest tables on an instance
Here is a quick script that I find myself using frequently to find the largest tables on an entire SQL Server instance.
Latest Service Packs – To Install or Not to Install?
It is interesting, when working with many different clients, the questions about installing Windows Updates and SQL Server updates comes up and often the discussion… Read More »Latest Service Packs – To Install or Not to Install?
CheckDB Error Msg 824 level 24
One of the common CheckDB errors that I see is the Message 824, level 24. This is something that I regularly work to repair for… Read More »CheckDB Error Msg 824 level 24
Prevent Server Manager From Loading
If you frequently connect to many different SQL Server as I do, you are probably used to the Server Manager loading slowly when you log… Read More »Prevent Server Manager From Loading
Building a SQL Restore Script When Your Backup Runs
It is handy to have a SQL Restore script ready to go for every backup that you run. Here is a script that will help… Read More »Building a SQL Restore Script When Your Backup Runs
Visualizing VLFs – Another update
This is an update to Visualizing VLFs – A while back a wrote a blog post with a query to Visualize the VLF’s in your database. Today I have an update to that script.
The previously updated script added another column called “TextStatus” to the output to give you a better idea of what the different statuses mean. You now get 3 statuses shown, “In Use”, “Available”, and “Available Never Used”. The If you have lots of VLFs that are “Available Never Used” that may be an indication that your log file may be larger than you need. If you don’t have any that are “Available Never Used” the log may be smaller than you need.
This latest update changed the character shown in the bar chart to a X or an O depending on if the current file is in use.
Read More »Visualizing VLFs – Another updateUsing Antivirus with SQL Server
In a perfect world, your SQL Server would be so secure that you would not need antivirus software, you would have behind layers of firewalls,… Read More »Using Antivirus with SQL Server
TempDB – Do This and Don’t Do That
Today I had the opportunity to present on TempDB to the Spokane SQL Server users group (PASS Chapter). The session was titled TempDB – Do This… Read More »TempDB – Do This and Don’t Do That
Visualizing VLF’s – Updated
A while back a wrote a blog post with a query to Visualize the VLF’s in your database. Today I have an update to that script.
Here is an updated script that has adds another column called “TextStatus” to the output to give you a better idea of what the different statuses mean. You now get 3 statuses shown, “In Use”, “Available”, and “Available Never Used”. The If you have lots of VLFs that are “Available Never Used” that may be an indication that your log file may be larger than you need. If you don’t have any that are “Available Never Used” the log may be smaller than you need.