Most of the people know about the right-click option 'View Dependencies' in the SQL Management Studio.
It will diplay expandable tree off all dependencies each way. Correct me if I'm wrong, but I couldn't find any other way to save this othere than taking a screenshot of the window.
2014-07-21 (first published: 2014-05-19)
950 reads
This is an example of how to Cache Query results on the Server side
then page though the results
2014-06-06 (first published: 2014-05-05)
2,280 reads
this is a powershell script that can start a job at a defined step name (default will be step 1), on a network instance either on a network on locally.
2014-06-04 (first published: 2014-05-05)
789 reads
2014-05-30 (first published: 2014-05-05)
1,519 reads
2014-05-28 (first published: 2014-05-02)
2,136 reads
This script returns a list of all the fields of a table with it properties, primary keys and user defined types.
2014-05-23 (first published: 2014-04-30)
1,758 reads
Size of database files for an instance of SQL Server
2014-05-07 (first published: 2014-04-10)
1,332 reads
Return a list of databases which contain a table from wildcard table name.
2014-05-05 (first published: 2014-04-14)
1,216 reads
2014-05-02 (first published: 2014-04-09)
1,795 reads
2014-05-01 (first published: 2014-04-09)
1,529 reads
By James Serra
(This post starts a three-part series on how AI is changing the way we...
I built a free library of runnable SQL Server demos. Each reproduces a real...
By Steve Jones
I was looking over the CHOOSE() function while editing an article at SQL Server...
We're currently in Azure, however as we had a very tight migration timeline when...
I have a section of code similar to the following abstract: DECLARE @loop [int]...
Hello everyone, I am planning to implement a data purging solution that is expected...
In SQL Server 2022+, what does the ##MS_DatabaseConnector## role allow?
See possible answers