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)
957 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,528 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,761 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
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers