|
|
|
SSC-Addicted
      
Group: General Forum Members
Last Login: Wednesday, February 15, 2012 9:18 AM
Points: 415,
Visits: 4
|
|
|
|
|
|
Old 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
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:27 PM
Points: 2,007,
Visits: 6,040
|
|
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
|
|
|
|
|
SSC-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.
|
|
|
|
|
SSC-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
|
|
|
|
|
SSCrazy
      
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 4:27 PM
Points: 2,007,
Visits: 6,040
|
|
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
|
|
|
|