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 […]
Category: Scripts
T-SQL Scripts
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 […]
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 […]
A Trio of Functions
I found myself perusing an execution plan the other day. I know, big surprise there. This execution plan showed me some interesting things I had never really paid much attention to in the past. When […]
Database Data and Log Size Info
Have you ever wanted or needed to get the data and log file size for all of the databases in your server? I have seen scripts that would get this information in the past. All […]
Table Space – CS Part Deux
Another script, another day. And as promised, I am providing an update to the Table Space script that followed the sp_MStableSpace script. Not a lot more to be said about this one, since much was […]
Table Space revised Again
Since I am in the Collation Sensitive mood, I am finally getting around to updating this script. This is the Table Space script that I have had out there for a while. In the last […]
Table Hierarchy goes CS
At the urging of a friend, this script is being updated for those that are dealing with Case Sensitivity. The first few rounds, I neglected Case Sensitivity and never tested for that. It makes sense […]
TSQL Challenge 63 – Update
If you recall, I like Sudoku. I even posted a script for solving it via TSQL. I went so far as to enter my script into a TSQL Challenge. That all started way back in […]