Comments
Sort by recent activity
I see this is a duplicate post. I searched before I posted, but apparently your forum doesn't do partial matches.
ie. Searching for reseed will not match reseeding. / comments
I see this is a duplicate post. I searched before I posted, but apparently your forum doesn't do partial matches.
ie. Searching for reseed will not match reseeding.
Will you please sent this to me as well? SQL Data Compare is mangling my database. I have to run SQL Compare after synchronize to turn some of the check constraints back on. / comments
Will you please sent this to me as well? SQL Data Compare is mangling my database. I have to run SQL Compare after synchronize to turn some of the check constraints back on.
I have seen this in several .NET applications. There doesn't appear to be any rhyme or reason, but Red Gate is not alone in this. I've even seen this in SSMS. / comments
I have seen this in several .NET applications. There doesn't appear to be any rhyme or reason, but Red Gate is not alone in this. I've even seen this in SSMS.
Chris Auckland wrote:
Thanks for your post.
Inserting and updating tables that are referenced by Indexed Views is very slow in SQL Server. Operations that would take a minute can take an hour. SQL Data Compare should drop these indexes before updates and recreated them afterward.
SQL Data Compare has the option to 'Drop primary keys, indexes, and unique constraints'. This option will drop and then recreate the PK's, indexes and unique constraints in the generated SQL script. The option can be found in Options > Synchronization Behaviour. Hopefully it will do what you need.
This does not drop Indexes on Views that reference the table. That's my point. It really should. These indexes place constraints on the table just as if there were on the table itself and the enforce schemabindding on the table. / comments
Chris Auckland wrote:
Thanks for your post.
Inserting and updating tables that are referenced by Indexed Views is very slow in SQL Server. Operations that would take a minute can take an hour. S...