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)
956 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,290 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)
792 reads
2014-05-30 (first published: 2014-05-05)
1,527 reads
2014-05-28 (first published: 2014-05-02)
2,138 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,760 reads
Size of database files for an instance of SQL Server
2014-05-07 (first published: 2014-04-10)
1,335 reads
Return a list of databases which contain a table from wildcard table name.
2014-05-05 (first published: 2014-04-14)
1,221 reads
2014-05-02 (first published: 2014-04-09)
1,800 reads
2014-05-01 (first published: 2014-04-09)
1,529 reads
By Rayis Imayev
"I've seen things you people wouldn't believe..."— Roy Batty, Nexus-6 Replicant, Blade Runner (1982)(2026-Nov-08) Yep,...
By Steve Jones
We’ve celebrated our birthday many times at Redgate. In the Book of Redgate –...
Discover how Palantir connects enterprise data, supports AI-driven decision-making and helps companies turn insights...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Too Many Choices
Comments posted to this topic are about the item Table Partitioning in SQL Server:...
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers