When administering a larger database environment, sometimes one needs to perform repetitive tasks. Performing repetitive tasks becomes more and more painful (maybe even demoralizing) with the larger the number of databases that might exist on […]
Tag: SQL Script
SQL Hide ‘n Seek
When was the last time you had to find something within your database? Did it feel more like a child’s game or an arduous task? What would you say if it could be more like […]
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.
Database In Recovery
What do we do? Have you ever run into a database that is in the “In Recovery” state? If that has happened, have the bosses and/or endusers come to you asking “What do we do?” […]
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 […]
Physical or Virtual
Today I get to share something that has been on my someday list for quite some time. I have planned on getting a solution that involves TSQL to help determine if you are running SQL […]
Views in Use?
Today, I am following up on a topic I mentioned in an earlier post. In case you haven’t read the post on finding your linked servers, you can read it here. It is in that […]
Are my Linked Servers Being Used?
This is a follow up to an article published on 3/1/2012. That article showed how to find what linked servers were created on your instance of SQL Server. You can read it here. This article […]