From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are a few tools at your disposal to look up that information. The required/requested information is […]
Category: Scripts
T-SQL Scripts
Column Level Permissions
Did you know that you can grant permissions down to the column level in SQL Server? Well, if you didn’t know that – you do now. It is actually rather simple to grant permissions […]
Activity Monitor and Profiler
Today I came across a link to a neat little script for SQL 2005 / 2008 to help derive the head blocker in a blocking chain. That script can be found here. I was looking […]
Foreign Key Hierarchy Update
Today I would like to revisit a post of mine that is rather old. More precisely, the script in that post needs revisiting. This is one of my more favorite scripts and I still have […]
NULLIF
Do you use NULLIF? For me, this command has been seldom used. Because of that, I have been dabbling with it a bit lately to make sure I have a better understanding of it. What […]
T-SQL Tuesday #016: Aggregates and Statistics
For my data analysis and trending, I wanted to find a simple distribution across quartiles.
SQL 2005 TableSpace
In the first post of this series I highlighted and described two stored procedures that are shipped from Microsoft. These stored procedures use different methods to display information about a table in a SQL Server […]
BLOB Index Columns
For the April T-SQL Tuesday, I blogged about a report to find information on the BLOBs in a database. I have since seen a request to add to that script. The addition would add some […]
Index Stats Duplication
I came across a recent posting about seeing multiple entries in sys.dm_db_index_usage_stats for the same index. This kind of behavior can be somewhat concerning since that view should have a unique entry for each index. […]
IP and Default Trace…T-SQL Tuesday #005
When it is necessary to provide reports on activity occurring on the server, it pays to do a little prep work. Be Prepared. It is not an easy task to be able to go back in time and report on data that isn’t captured. The little prep work that one may need to do is well worth the effort in the end.