Get all the Child Tables up to N level
Get all the dependent tables for a master table up to N level(Till the leaf ) you can either find dependency or you can find all the child tables.
2021-04-14 (first published: 2013-09-04)
3,135 reads
Get all the dependent tables for a master table up to N level(Till the leaf ) you can either find dependency or you can find all the child tables.
2021-04-14 (first published: 2013-09-04)
3,135 reads
This script will tell you how many indexes there are for a single table and also it specifically shows how many non clustered index, and also which tables have a heap index.
2021-04-14 (first published: 2012-10-17)
1,126 reads
2013-12-26
1,758 reads
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
By Steve Jones
I have been experimenting more and more with ChatGPT on a regular basis. I’m...
Hi, I have a few AWS EC2 instances currently running SQL Server 2016. I'd...
Hello, I need help to improve an existing (hence I cannot change table's structure...
In Brent Ozar's list of links today, I learned that Microsoft has removed the...