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)
2,027 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,020 reads
By MUTHUKKUMARAN KALIYAMOORTHY
Requirement: Remove a node from one of... [[ This is a content summary only. Visit...
By Steve Jones
At SQL Saturday #884 – Pensacola, I dropped into Rodney Ladrum’s session on Azure...
My last two blogs were on understanding columnstore and creating columnstore indexes. In this...
Comments posted to this topic are about the item The AI Manager
Hello! I have column in SQL 2012 DB of datatype smallint. Could you please...
When we try to create a SQL Server Agent job schedule that has a...
Ask SSC