Recently a need resurfaced to explore the foreign key tree (hierarchy/genealogy) as it related to a specific table within a database. As I pulled out the script from the repository, I realized there was some […]
Tag: Scripts
T-SQL Tuesday #050: Automating Database Restores
Here it is time for the party of the month for the SQL Server acolytes and I was running a bit behind. Why? Well, that was due in part to me rushing around trying to […]
Where have all the Orphans gone?
Do your database users appear to be having an out of body experience? Have they lost all ties to their login? Does it feel like maybe what this baby rhino might be experiencing – just […]
SQL Hide ‘n Seek
When was the last time you had to find something within your database? Did it feel more like a child’s game or an arduous task? What would you say if it could be more like […]
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 […]
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 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 […]
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 […]