SQL RNNR

On more than one occasion, I have run into a case where a large database with a large transaction log was being mirrored.  Then a hiccup comes along – the transaction log on the primary server grows to a point where the transaction log on the secondary server fills the [...]

LAUNCH If you have been hiding under a rock, you have probably not heard that SQL 2012 has launched.  With it, some really cool features are now available to use in our SQL database environments. Some of these cool new features include some new DMVs, the AlwaysOn feature, and columnstore [...]

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

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, I [...]

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

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

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 Jack of [...]

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

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, [...]

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 client [...]

Thanks Robert.

Nice tip, Jason! Going to share it on DBA.Connect, and other Linkedin groups....

Thanks Jason. I know for certain that none of our queries use hints, so that's a non-issue. But ...

The script can certainly be changed to look at that. I did this script knowing that I only wanted ...

Okay, bear with me because I might be a wee bit dense. I'm a bit of a n00b. "I want ...

The purpose for that condition is to eliminate all indexes that have been used in some fashion. In this ...

I do have a follow-up question, if you don't mind. What exactly is the purpose of this line: And (user_seeks ...

Thanks. I am glad you said test. I can't stress enough the importance to research and test before ...

One of my scheduled tasks for today was to work on a script to do exactly this. Thanks for ...

Muddy is an interesting way of stating it. Seems like something else is more fitting;)