Archives: March 2012
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 better indexes.
SQL Server provides a means to find the information we seek. We can… Read more
In October of 2011, I shared an example of a peculiar set of sort requirements. Today, I am going to share another similar set of requirements. Based on prior experience, when I saw this request on a sort order, I was sure I could find a simpler solution. Today,… Read more
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 want/need to find out what SQL Agent jobs are running SSIS packages. This script will… Read more
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 of data about tables in a database. This information was table size and missing foreign… Read more
This month, Argenis has invited us to talk about demons from our past. Ok, not necessarily demons but at least share why you might be a… Read more
If I were to show you the tabs in the following pic without a description, would you recognize the websites to which they belong?
I would dare say that you would likely recognize them. Not due to the labels on the tabs, but quite possibly due to the icon on… Read more
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 Server on a physical machine or if it happens to be a virtual machine. Now,… Read more
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 post that I spoke of altering a script I had just written for another… Read more
Today is Meme Monday. Today we get to talk about all of the little things a DBA does. Thomas LaRock started things off with his list – here.
I want to just add to the list he started.
- SAN Admin
- Server Admin
- Technical Writer
- Project Manager
- Automate the process…
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 came about due to a request to find if any stored procedures are using… Read more
Finding Linked Servers
SQL Server has provided us means to be able to find the linked servers on each installed instance. I will show two simple means (that don’t involve… Read more