SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: March 2012

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 better indexes.

SQL Server provides a means to find the information we seek.  We can… Read more

7 comments, 2,338 reads

Posted in SQL RNNR on 20 March 2012

Another Interesting Sort

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

0 comments, 821 reads

Posted in SQL RNNR on 19 March 2012

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 want/need to find out what SQL Agent jobs are running SSIS packages.  This script will… Read more

0 comments, 840 reads

Posted in SQL RNNR on 15 March 2012

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 of data about tables in a database.  This information was table size and missing foreign… Read more

0 comments, 1,082 reads

Posted in SQL RNNR on 14 March 2012

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.  Ok, not necessarily demons but at least share why you might be a… Read more

0 comments, 860 reads

Posted in SQL RNNR on 13 March 2012

What is a Favicon?

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

0 comments, 781 reads

Posted in SQL RNNR on 8 March 2012

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 Server on a physical machine or if it happens to be a virtual machine.  Now,… Read more

2 comments, 2,111 reads

Posted in SQL RNNR on 7 March 2012

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 post that I spoke of altering a script I had just written for another… Read more

1 comments, 672 reads

Posted in SQL RNNR on 6 March 2012

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 list he started.

  1. SAN Admin
  2. Server Admin
  3. Technical Writer
  4. Project Manager
  5. Automate the process…

Read more

2 comments, 759 reads

Posted in SQL RNNR on 5 March 2012

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 came about due to a request to find if any stored procedures are using… Read more

0 comments, 1,102 reads

Posted in SQL RNNR on 5 March 2012

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 linked servers on each installed instance.  I will show two simple means (that don’t involve… Read more

1 comments, 1,040 reads

Posted in SQL RNNR on 1 March 2012