Activity overview
Latest activity by Igor.Tochansky
Sorry for this, you are right: filtered indexes have been added since 2008 server.
Probably, you should close the bug. / comments
Sorry for this, you are right: filtered indexes have been added since 2008 server.
Probably, you should close the bug.
Hello Brian!
I reproduced it today on databases located on this env.:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)
You are right, the problem is about compatibility levels.
I used value of "90" (2005) for "source" DB and value of "100" for "target" DB.
Both levels support filtered indexes.
The script to create "source":
create table TBL
(
col1 int null
)
create index IX1_TBL on TBL (col1) where col1 = 0
The script to create "target" (the column is not null):
create table TBL
(
col1 int not null
)
create index IX1_TBL on TBL (col1) where col1 = 0
/ comments
Hello Brian!
I reproduced it today on databases located on this env.:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1617.0 (X64) Apr 22 2011 19:23:43 Copyright (c) Microsoft Corporation Develope...
A small problem with filtered indexes
Hello!
I have downloaded a SQL Compare today and found a small bug.
The problem is about filtered indexes.
In fact, they are compared right and are not included into the deployment script if they a...