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 […]

T-SQL Tuesday #028 – Jack of All Trades, Master of None?

Another month and another opportunity to write about an interesting topic.  This month hosting TSQL Tuesday is Argenis Fernandez (Blog | Twitter). This month, Argenis has invited us to talk about demons from our past. […]

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 […]

A DBAs List of Little Things

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 […]

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 […]

Linked Servers

Do you have linked servers that have been created in your environment?  Do you know what these linked servers are? Finding Linked Servers SQL Server has provided us means to be able to find the […]