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 […]
Tag: TSQL
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 […]
Missing Indexes
SQL Server has means built into it to track possible missing indexes. This used to be found through the use of the Index Tuning Wizard. The process has improved over time (you can sort of […]
TSQL Tuesday #26 or #23 – Identity Crisis
This second chance, gives me the opportunity to finally talk about a topic that has been on my to-blog list for quite some time. I hope this post will show some different ways of joining in TSQL.
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 […]
T-SQL Tuesday #024: Prox ‘n’ Funx
Functions are very handy. They can also prove to be the cause of poor performance (such as was the case with that string splitter). When used appropriately, you can provide well-performing SQL as well as some very handy information.
Another Color Wheel
Some time ago, I had the opportunity to work on a problem involving the color wheel. The requirements for that problem lent themselves to a solution involving bitwise operations (which you can read here). I […]