Posts
Sort by recent activity
Formatting of filegroups on indexes
Actually two questions
My current style produces this:
USE tempdb;
GO
RAISERROR('dummy error message', 16, 1)WITH LOG;
GO
CREATE NONCLUSTERED INDEX IXF_dbo_tablename_columnname
ON dbo.tablename...
Disabled index issue
It looks like the disabled flag inon indexes is not taken into account when comarign tables in v12.0.39.3632.
CREATE TABLE dbo.RGTest (ID INT IDENTITY(1, 1)
...
Progress % display issue
When refreshing tables in the "tables & views" dialog box I regularly see the progress indicators display percentages of more than 100% in some case 5000% and more. I can reproduce this by running ...
XML formatting bug - v7.3.0.610
Just downloaded the new Adam Machanic's sp_whoisactive script from http://whoisactive.com/.
When using the traditional SQLPrompt re-formatting it will incorrectly format the followign code segment
...
DATE comparison bug - v12.0.32.3340
When comparing date-time data types SQL DataCompare first converts certain date-time data types to VARBINARY(MAX) when selecting the data int he source/destination database instead of retaining the...
Custom mapped columns issue
DataCompare latest version:
I am comparing two tables where I did a custom mapping of two columns due to the column names not matching. In a first comparison I compared all columns. Afterwards, I r...
Foreign key issues
It looks like foreign keys are not being dropped if they are referencing an index and the index needs to be dropped. My settings do specify that foreign keys should be disabled
Missing filter indicator
V12 latest version.
If I apply a WHERE clause filter to a table I no longer see any type of visual indicator that the particular table has a filter applied. And it is cumbersome to check hundreds o...
Progress indicators missing
SQL Data Compare version 12.0.31.3232
There is no progress indicator displayed when creating the DataCompare script for large changes, e.g. changes to 100,000+ records where it takes a couple of se...
Table names incorrect in progress dialog box
SQL Data Compare version 12.0.31.3232
I have a variety of tables that contain underscores as part of the names. If I run DataCompare on those tables then the progress dialogs do cut off the first u...