I recently came across an interesting script to help show index info and usage. As I began to dissect the script, I noticed that the script was intended for SQL 2005 and beyond but was […]
Category: Scripts
T-SQL Scripts
FizzBuzz Revisited
I had bigger plans for this series than what has transpired. I think that is a testament as to how things can rapidly change or other events can change your plans. The first thing that […]
Security Audit
This article demonstrates a script that will generate a nice html report of your database security suitable for the auditors.
Index your FK
A few months ago I read an article from SQLServerCentral.com about some Foreign Key gotchas. Since that article, I have seen several people asking about whether a foreign key should be indexed or not. I have […]
Key Discovery III
Recursively traverse system views to build a Hierarchical Perspective into the database.
SQLFool IDX Defrag Scripts
I just found out that Michelle Ufford (@sqlfool) has updated her Index Defrag scripts. Right now she is looking for Beta testers. Anybody that is interested could find more info at: http://sqlfool.com/2010/01/index-defrag-script-updates-beta-testers-needed/
Primary Key Discovery
As a part of my DB documentation process for a large database, I needed a method to quickly show me all of the Primary Keys in the database. Not only did I want the PKs, […]