SQL Server Performance

  • Home
  • Articles
  • Forums
  • Tips
  • Training
  • FAQ's
  • Blogs
  • Software
  • Books
  • About Us
RSS Feeds
Sign in | Join


Product Reviews

All Reviews
Audit Tools
Backup Tools
Change Management Tools
Clustering Tools
Coding Tools
Design Tools
Diff / Compare Tools
Documentation Tools
Job Management Tools
Log Recovery Tools
Monitoring Tools
Remote Access Tools
Reporting Tools
Security Tools
Testing Tools

USEFUL SITES :

ASP.NET Tutorials
Windows and SQL Azure Tutorials
Cloud Hosting Magazine
SharePoint Tutorials
Windows Server Help

Write for Us

Share your SQL Server knowledge with others and raise your profile in the community More...
Latest Articles

A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server - Part ...
A High Level Comparison Between Oracle and SQL Server

More     
 
Latest FAQ's

Add Node to A SQL Server failover Cluster failed with invalid ...
SQL Server Destination remote server error
Setting Up Data And Log Files For SQL Server
Will Check Constraints Improve Database Performance?

More     
   
Latest Software Reviews

dbForge Review
Spotlight on ApexSQL Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Data Diff - Server-based database comparison tool ...
Spotlight on ApexSQL Doc 2008

More     

reviews >> audit tools >> ApexSQL Clean: Impact Analysis and Graphical Dependency ...

ApexSQL Clean: Impact Analysis and Graphical Dependency Viewer tool

By : Frank Kalis
Feb 22, 2007

Page 2 / 10

Dependency Analysis Wizard

Well, step by step, the first thing you do is to create a new "Dependency Analysis Project". This invokes the Dependency Analysis Wizard, at which I will have a closer look now:

You can also use the wizard to edit the current project settings and/or restore previously used setting or open another already existing project. Since this is the first time I use the software, I obviously need to create a new project.

The above page of the wizard is not new to anyone working with SQL Server. It's the typical login screen, where you specify your login credentials.

Sometimes it can happen that a database is not its self-contained universe, but rather has references to other databases. If that is the case, ApexSQL Clean allows you to add such references to other databases residing on the same SQL Server instance, as the above picture shows. All checked databases will be included in the analysis. It should be noted, that the feature to include external databases allow you not only to search for child references, but also for parent references as well. This is quite remarkable as it allows you to deal with situations where, for example, a database gets loaded regularly from some other staging database or where you use some other database for report, auditing or archiving purposes.

This page here at hand allows you to specify comment tokens in source code files of client applications that will be ignored from analysis. Typically you would add here the comment tokens of the client language you use, such as VB, C#, or C++. Single line tokens are as well supported as multi-line comment tokens.


<< Prev Page     Next Page>>    








C# Help and Tutorials | PHP MySQL Tutorial | Sharepoint Tutorial | Azure Tutorial | Cloud Hosting Magazine | ASP.NET Tutorials | Windows Server Help | Windows Phone Pro | Silverlight Ace | Visual Studio Tutorials | Home | Peformance Articles | Audit Articles | Business Intelligence Articles | Clustering Articles | Developer Articles | Reporting Services Articles | DBA Articles | ASP.NET / ADO.NET Articles | SQL Server Training Videos | DBA FAQ's | Developer Peformance FAQ's | DBA Peformance FAQ's | Developer FAQ's | Clustering FAQ's | Error Messages | Audit Tool Reviews | Backup Tool Reviews | Coding Tool Reviews | Compare Tool Reviews | Documentation Tool Reviews | Design Tool Reviews | Monitoring Tool Reviews | Log Tool Reviews | Reporting Tool Reviews | Clustering Tool Reviews | Security Tool Reviews | Change Management Tool Reviews | Remote Access Tool Reviews | Book Reviews | Security Tool Reviews | ADO.NET / ASP.NET | Administration | Analysis/OLAP Services | Application Development | Configuration | Components | ETL | Hardware | High Availability | Hints | Index | Misc | Operating Systems | Performance Tuning | Replication | T-SQL | Views


              © 2010 Jude O'Kelly. All rights reserved