By Scot Becker on
10/22/2004
In some DBMS’s, the order in which columns appear in the creation/definition of an index (which spans multiple columns) can have performance impacts. Should you be saddled with such a silly restriction, you might be wondering how to specify the column order within Visio.
Read More...
|
By Scot Becker on
10/18/2004
The primary supertype setting is enabled if a subtype has two or more parent supertypes (i.e. multiple inheritance).
Read More...
|
By Scot Becker on
10/18/2004
Occasionally (and especially when a predicate also has ring and/or frequency constraints), it is convenient to display an internal uniqueness constraint on the bottom of the predicate instead of on the top.
Read More...
|
By Scot Becker on
7/28/2004
The Visio for Enterprise Architects (VEA) constraint editor can be a little confusing when it comes to creating set (subtype, equality, and exclusion) constraints. I’ll describe how to create these constraints using examples from a related entry.
Read More...
|
By Scot Becker on
2/3/2004
Different versions of Visio have different data modeling capabilities.
Read More...
|
By Scot Becker on
2/3/2004
The default version for the MS SQL Server ODBC driver is 7.0, which does not support the bigint datatype.
Read More...
|
By Scot Becker on
2/3/2004
To forward engineer a database from an ORM/ER Source Model, you must first create a Database Model Diagram and add the source models to the project.
Read More...
|
By Scot Becker on
2/3/2004
If you want to install Visio for Enterprise Architects, you must first install Visual Studio .Net. However, if you really do not wish to install Visual Studio, you can do a "mini" install.
Read More...
|
By Scot Becker on
2/3/2004
Visio wraps all database object names in quotes when it generates the SQL DDL.
Read More...
|
By Scot Becker on
2/3/2004
Some versions of Visio contain a bug where it is possible to orphan relationship lines such that the model will fail to validate/build.
Read More...
|
By Scot Becker on
2/3/2004
Visio for Enterprise Architects is not installed via the same installation wizard as Visio Studio .Net.
Read More...
|
By Scot Becker on
2/3/2004
How to make an existing column into an identity column.
Read More...
|