Today’s stored procedure that you can use in your DBA database is a re-hash of a post I did a couple months ago. The reason for re-hashing the procedure is that when I used it last week I found out there were some serious issues with its results. Some plans were being duplicated and the … Continue reading Really Search Cache for Execution Plans
Tag: Database Administration
Oops… A Lot Of Trees… Jobs to Update
Yesterday I posted about having an alert in place to know when SQL Agent jobs don’t have operators setup. I’ve found this alert to be extremely useful, but often when its been shared it just leads to junk e-mail. The reason for this is when the alert is added to 5, 10, or 50 servers … Continue reading Oops… A Lot Of Trees… Jobs to Update
But It Wasn’t My Job To Do The Backups!?
It’s happened a few times, I go out to assist with recovery from some sort of failure and the question of database backups results in an uncomfortable pause. One group thought the other group was taking the backups and the other group didn’t know that the backups needed to be taken. And neither group previously … Continue reading But It Wasn’t My Job To Do The Backups!?
Does A Job Really Fail If Nobody Knows About It?
Have you ever gone out and made a new SQL Agent job and forget to assign notification settings for it? God, I hope I’m not the only one because that would mean I suck. This is a common issue that exists in most environments that I’ve worked in. So I must not suck. Quite often … Continue reading Does A Job Really Fail If Nobody Knows About It?
Snapshots of Index Contention
Occasionally, I need to determine where index hotspots are located within databases. To do this, I use the DMV sys.dm_db_index_operational_stats. I’ve talked about this DMV before while I was going through the index analysis blogs posts. This DMV returns locking and blocking information for tables and indexes in the database. This information is aggregated since … Continue reading Snapshots of Index Contention
Database File Information
I often go out to clients and have to do some quick analysis of the client’s SQL Servers. Below is one of the SQL scripts that I’ll use when I want some to give some quick feedback on whether the files and their properties are configured properly. Not a very tricky script but something that … Continue reading Database File Information
Change Trusted State of Foreign Keys
Ever want to change those foreign keys created with NOCHECK to CHECK? Not exactly an earth shattering requirement but having all of the foreign keys trusted helps keep the relationships in your databases solid. Exactly what a good foreign key should be doing. Changing the foreign key to trusted does have the risk of uncovering … Continue reading Change Trusted State of Foreign Keys
Find Duplicate Foreign Keys
A few weeks back I was working on a process that would utilize foreign keys to crawl from table to table to export data from a production database to an archive database. More on some of what went into that process probably at some point in the future. When the project was released to production … Continue reading Find Duplicate Foreign Keys
Strate SQL 