Posts
Sort by recent activity
Odd partioning behaviour
Where I have a table that is partioned and this has partitioned indexes if the column used by the index for the partitioning scheme differs from that used by the table then SQL Compare incorectly t...
Confussion where objects have the same name
We have a large Data Warehouse where there are stages to bringing the data in and we used schemas to designate the layer.
So for instance there is a Staging table in the schema Staging_something, a...
Some Schema drops report as constant changes
If you drop the schemas db_owner, db_accessadmin, db_backupoperator and others, Source Control constantly reports these as changes, ie that the schema drop has happened since the last commit and ne...
FillFactor Bug with User Defiend Table Types
SQL Compare seems to have a bit of a bug when it comes to User Defined Table Types.
If The Soruce and Destination server have different Index default fill factors SQL Compare adds a fill factor to ...
Smart rename is great - but annoying
As a feature request could you please order the schema list in Smart Rename alphabetically. At the moment this great feature is severely hampered for us by the fact our list of 149 schemas appears ...
Visual Query Editor - feature wish list
Despite being a bit of an old dinosaur I do from time to time use the visual query editor in Visual Studio to make quick changes to a simple query. However the following issues stop me using it on ...
Two part name joins for three part name data tables
Having a database building database I frequently access external database schemas from the build database. So for instance where I have a database called External_DB I may use the following query.....
Database name as a parameter
I appreciate the facility to ignore the Database name when object naming includes it in synonyms, but I wonder if you might take it one step further for me?
We have a number of instances on the sam...
Changing the Compression on a table is not a schema change
As part of a system test I set compression on my database tables, (all 3200 of them) to NONE as I was investigating some of the issues with estimated cardinality being wrong on SQL Server 2008 R2. ...
DATA_COMPRESSION = PAGE causes an error when using SVN
We are using SVN and when I check in a table which has both for the table and the indexes DATA_COMPRESSION = PAGE (using SQL Server 2008 R2), the check in works fine, all susequent attepts to check...