SQL Scripts: How To Find Index Fragmentation
This is the first post in an ongoing SQL Scripts series, in which I list useful queries that I use in my day to day database administration. What Is Index Fragmentation? …
List All Foreign Keys Referencing A Table In SQL Server
There may be times that you need to get a list of tables that have foreign key constraints back to a table that you’re working on. Fortunately, SQL Server has a built …