Activity overview
Latest activity by shawnC
We have a team of 15 developers all using SQL Source Control, all on the latest version to fix the "dbo schema" errors.
The software is killing our servers: people are unable to check in
When is this update due please? Where can we get the file mentioned above? / comments
We have a team of 15 developers all using SQL Source Control, all on the latest version to fix the "dbo schema" errors.
The software is killing our servers: people are unable to check in
When is th...
Bugs don't get fixed and you can't see the list of bugs either / comments
Bugs don't get fixed and you can't see the list of bugs either
They don't bother fixing much these days.
I'm going right off SQL Compare because of continual low level unfixed bugs. / comments
They don't bother fixing much these days.
I'm going right off SQL Compare because of continual low level unfixed bugs.
One year later... any update please? / comments
One year later... any update please?
Detection of Logins should use SUSER_ID
The code generated to test for an existing SQL login is thisIF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE loginname = N'xxx')
CREATE LOGIN [xxx] WITH PASSWORD = 'p@ssw0rd'...
One year later... any update please? / comments
One year later... any update please?
any update please? / comments
any update please?
Thanks Brian
My reported bug is about disabled indexes (sys.indexes.is_disabled), not constraints as such
Obviously a unique constraint and a primary key are indexes, but explicit indexes (CREATE INDEX) that are disabled are not detected: neither are indexes (from constraints) from CREATE TABLE
So, neither the PK nor IX_Other or IXCU_PK are detected. Only the table PK has a system generated name, the others are explicitly named / comments
Thanks Brian
My reported bug is about disabled indexes (sys.indexes.is_disabled), not constraints as such
Obviously a unique constraint and a primary key are indexes, but explicit indexes (CREATE I...
SQL Compare does not detect disabled indexes
Hi
tl;dr: SQL Compare does not detect disabled indexes
More...
I was playing with a bulk load script for test data.
In this, I disable constraints (CHECK and FK) and triggers.
However I wanted to d...
Note: this *only* happens when you use a filtered index.
Using a WITH clause alone works OK. But not when you have a WITH and WHERE clause.
So there's no confusion... / comments
Note: this *only* happens when you use a filtered index.
Using a WITH clause alone works OK. But not when you have a WITH and WHERE clause.
So there's no confusion...