Easily extractss the complete stored procedure call hierarchy from "sysdepends" table of SQL Server and represent it in a pseudo-graphical tree-view.The script uses a temporary table (automatically created/dropped) to hold children and parents of relationships. For representing the call hierarchy the table contains a level field (depth) and a field containing the "enumerated path" (using […]
2005-03-14 (first published: 2005-03-01)
3,901 reads
Gets most important information of database structure. This includes all user tables, their fields, datatypes, defaults (including default constraint names), etc, primary keys and their fields, unique constraints and their fields, check constraints (including their conditions), foreign key constraints and their fields aswell as any other indexes and their fields. Should be quite useful for […]
2002-04-08
3,036 reads
By Brian Kelley
If a technology is still viable, don’t overlook it. Don’t get caught up chasing...
By Steve Jones
It’s time for the monthly T-SQL Tuesday blog party. This month a longtime friend,...
By Steve Jones
I got a message a few months back that Microsoft was deprecating the MySQL...
Comments posted to this topic are about the item Starting to Estimate Disk Storage...
Comments posted to this topic are about the item Keep. It. Simple.
Hello, I'm trying to remove results from this sql statement where the custid like...
If I have durable memory-optimized tables, what is the starting point for estimating storage space?
See possible answers