Today we have another update for an age old script on this site. You can find the last update to the script here. This time we have a bit of a bug update. The details […]
Category: Scripts
T-SQL Scripts
Table Hierarchy updated
Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a database. As I pulled out the script from the repository, I realized there was some […]
T-SQL Tuesday #050: Automating Database Restores
Here it is time for the party of the month for the SQL Server acolytes and I was running a bit behind. Why? Well, that was due in part to me rushing around trying to […]
Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server? Are you wondering when the setting for max degree of parallelism was changed? Do you know who changed […]
Backup History
This is a quick rewrite of the script I just posted a few days ago. The script had a few flaws if trying to run it on a SQL 2005 box. I have updated it […]
Last Known Good CheckDB
Diligent DBAs like to check their databases for a little thing called corruption. Some of those DBAs are masterful at keeping records and logging that the database was checked and came up with a clean […]
Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times we inherit some things that are just plan annoying. Yet other times, we inherit things that may be annoying and we probably just haven’t discovered them yet.
Seldom Used Indexes
On occasion you may ask yourself if there are any under used indexes in your database. If not you, then possibly a manager or client. Usually this comes up when evaluating for missing indexes or […]
Agent Jobs Using SSIS
This is a short script to help the DBA with documentation purposes. This would come in handy especially in those cases where you are consulting or you have taken on a new job. Suppose you […]
Table Size and Missing FK Indexes
I am bringing an oldie back with another twist. I recently ran into the need to correlate information between a couple of different queries that I like to use. The two scripts returned different pieces […]