Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Top Ten Features of Enterprise Manager Expand / Collapse
Author
Message
Posted Friday, October 15, 2004 11:52 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, February 15, 2012 9:18 AM
Points: 415, Visits: 4
Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists


All the best,

Dale

Author:
An Introduction to SQL Server 2005 Management Studio
Post #142042
Posted Tuesday, November 16, 2004 2:50 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, November 09, 2012 2:25 AM
Points: 395, Visits: 139
One nice thing you can do well using all of these EM features is have profiler running in the background. That way you can view all the SQL commands that are being used to generate these commands, very useful


Post #146433
Posted Tuesday, November 16, 2004 6:39 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:01 PM
Points: 2,007, Visits: 6,065
One thing missing from the list which is extremely useful...Taskpad.

Go to a database, then hit view-->Taskpad, it will give you a reperesentation of the database, along with log and data freespace, plus a tab with all the table and index information including rows and disk space used.




Shamless self promotion - read my blog http://sirsql.net
Post #146459
Posted Tuesday, November 16, 2004 10:18 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, September 21, 2012 7:39 AM
Points: 135, Visits: 128

One of the nice things in EM  missing in the list is the diagramming feature. Within the diagram, you can design the tables and relationships. Or simply, it allows you to reverse engineer or document your application.

Unfortunately, this feature seems to be going away in SQL Server 2005.

 




Post #146527
Posted Tuesday, November 16, 2004 10:16 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 24, 2011 1:55 AM
Points: 139, Visits: 43

The reason it is not present in 2005, i think, could be because tools like ERwin are much better at both forward & reverse engineering. From what I know we can add or-and create tables, design relationships and do basically everything which can be done in table design. Another benefit is that it can be useful for documentation purposes.

Are there any other benefits of the Digrams in SQL server EM?




What I hear I forget, what I see I remember, what I do I understand
Post #146654
Posted Wednesday, November 17, 2004 5:27 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 2:01 PM
Points: 2,007, Visits: 6,065
It may be that Erwin is better, but I think that they are using the Viso for .net architects aspect of the development tools in an attempt to supplement the bottom dollar.



Shamless self promotion - read my blog http://sirsql.net
Post #146719
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse