|
|
|
|
|
DBArtisan 4.01 1 2 3 4 5 6 7 8 9 10 To get at a list of indexes in Enterprise Manager, the user must highlight a table, right click, and select indexes and even then you can only see one index at a time of one table at a time. DBArtisan simply gives you a list of all indexes in a database by highlighting the indexes item. The view will show the owner of the index, name, table it is for, and whether or not it is clustered or unique. This gives all of the necessary information without having to dig around in dialog boxes. The one thing Enterprise Manager will give that DBArtisan does not is some extended statistics on the index.
Inside Enterprise Manager, unless there is a clear naming convention that is adhered to for triggers and stored procedures, you can not tell which is which unless you open the object and inspect the item because triggers and stored procedures are grouped together in the stored procedure list. DBArtisan gives you a separate list of stored procedures and triggers.
The biggest difference between Enterprise Manager and DBArtisan is the interface. Enterprise Manager opens everything in either a child or popup window. DBArtisan opens a separate tab when working with detailed information. One thing that is very handy is the ability to open multiple tabs for objects. Within Enterprise Manager, I can open a single ISQL window. DBArtisan allows me to open as many as I want. These can also be opened on multiple servers and databases within the single interface without highlighting a different server. This also applies to any trigger, procedure, table, index, user, login, etc. This ability to open multiple tabs for different objects makes comparing objects on opposite servers or databases very easy. |
All content on this site, except where noted, represents an original work of Michael R. Hotek and is protected by applicable copyright laws. The SQL Server FAQ is the sole work of Neil Pike. No page, portion of a page, or download may be used for commercial purposes in whole or in part without the express, written permission of the applicable author.
