November 26, 2006 at 10:44 pm
I have created a full text catalogue on my Addresses table with exactly same configuration on 3 databases. Two of them are on SQL 2005 and one on SQL 2000.
My Addresses table has 13 million rows and the full text was on the Full Address column.
FT Index on SQL 2005 database was created very quickly (within 2 hours) while SQL 2000 FT took 30 hours.
But my issue is SQL 2005 index does not contain all the words. For an example following 2 queries gives me the exactly same number (274) on the SQL 2000 database while on SQL 2005, first query only return 11 and the 2nd one 274 (274 = same on 2000 server/database as well)
SELECT count(*)
FROM [dbo].[Addresses]
WHERE
CONTAINS(FullAddress, 'WARMINSTER')
GO
SELECT
count(*)
FROM [dbo].[Addresses]
WHERE
FullAddress like '%WARMINSTER%'
Is this a bug?
When i extract the records not coming from the SQL 2005 FT search and put them on to a seperate table (few hundred records) and create a FT index on that i found that i actually includes all words and works fine.
November 27, 2006 at 3:00 am
Perhaps you have a collation problem on your original table in 2005?
November 27, 2006 at 3:20 pm
Both Server and database collation are same and set to Latin1_General_CI_AS. Even the Indexed Column collation is same.
One more thing about my SQL 2005 test databases is that they all restored using SQL 2000 backups.
November 28, 2006 at 10:07 am
Bimal,
First of all, it is very uncommon for both T-SQL LIKE and SQL Full-text Search (FTS) to always return the same number of results as both search methods are different. LIKE is more string pattern vs. SQL FTS is more language-specific for word or phrases.
Additionally, under SQL Server 2000 FT Indexing, the OS version wordbreakers were used and if your SQL 2000 database were installed on Windows 2000 vs Windows 2003 or Windows XP, you may see different FTS resutls as SQL 2005 uses the newer Windows XP / Windows 2003 word breakers vs. the older Windows 2000 wordbreakers. See my quoted reply in this thread for more details:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=117679
Could you reply back with the following SQL script output from both your SQL 2000 and SQL 2005 servers?
use <your_database_name_here>
go
SELECT @@language
SELECT @@version
EXEC sp_help_fulltext_catalogs
EXEC sp_help_fulltext_tables
EXEC sp_help_fulltext_columns
EXEC sp_help <your_FT-enable_table_name_here>
go
This will help further diagnose where the difference is that accounts for your search results.
Thanks,
John
SQL Full Text Search Blog
http://jtkane.spaces.live.com/
John T. Kane
November 28, 2006 at 6:02 pm
Thanks a lot John
for your support on this. I have added few more information as well.
These are
some of records which does not recturn by the full text serach with
CONTAINS
(FullAddress, 'WARMINSTER')
AddressID FullAddress
1491740 2C CCCCC STREET WARMINSTER WEETS VV2 8DZ
957818 32 WARMINSTER ROAD EEED XX VVV
On
SQL 2005
--------------------------------------------------------------------------------------------------------------------------------
us_english
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL
Server 2005 - 9.00.2153.00 (Intel X86)
May 8 2006 22
:41:28
Copyright
(c) 1988-2005 Microsoft Corporation
Enterprise Edition
on Windows NT 5.2 (Build 3790: Service Pack 1)
ftcatid
NAME PATH STATUS NUMBER_FULLTEXT_TABLES
----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------------------
6 cat_Addresses_Test O
:\FULL_TEXT\cat_Addresses_Test 0 1
7 cat_Addresses_AI O
:\FULL_TEXT\cat_Addresses_AI 0 1
TABLE_OWNER TABLE_NAME FULLTEXT_KEY_INDEX_NAME FULLTEXT_KEY_COLID FULLTEXT_INDEX_ACTIVE FULLTEXT_CATALOG_NAME
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ --------------------- --------------------------------------------------------------------------------------------------------------------------------
dbo _TEMP_ADDRESSES PK__TEMP_ADDRESSES 1 1 cat_Addresses_Test
dbo Addresses Addresses__PK 1 1 cat_Addresses_AI
TABLE_OWNER TABLE_ID TABLE_NAME FULLTEXT_COLUMN_NAME FULLTEXT_COLID FULLTEXT_BLOBTP_COLNAME FULLTEXT_BLOBTP_COLID FULLTEXT_LANGUAGE
-------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------- -----------------
dbo 475213539 _TEMP_ADDRESSES FullAddress 3
NULL NULL 1033
dbo 475213539 _TEMP_ADDRESSES PostCode 5
NULL NULL 1033
dbo 475213539 _TEMP_ADDRESSES LocalityName 6
NULL NULL 1033
dbo 475213539 _TEMP_ADDRESSES StateProvinceCode 7
NULL NULL 1033
dbo 475213539 _TEMP_ADDRESSES StateProvinceName 8
NULL NULL 1033
dbo 101575400 Addresses FullAddress 3
NULL NULL 1033
dbo 101575400 Addresses PostCode 5
NULL NULL 1033
dbo 101575400 Addresses LocalityName 6
NULL NULL 1033
dbo 101575400 Addresses StateProvinceCode 7
NULL NULL 1033
dbo 101575400 Addresses StateProvinceName 8
NULL NULL 1033
Name
Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
Addresses dbo
user table 2001-03-23 11:33:32.610
Column_name
Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
AddressID
int no 4 10 0 no (n/a) (n/a) NULL
FullAddress
nvarchar no 502 no (n/a) (n/a) Latin1_General_CI_AS
CountryID
int no 4 10 0 no (n/a) (n/a) NULL
PostCode
nvarchar no 22 no (n/a) (n/a) Latin1_General_CI_AS
LocalityName
nvarchar no 60 no (n/a) (n/a) Latin1_General_CI_AS
StateProvinceCode
nvarchar no 10 yes (n/a) (n/a) Latin1_General_CI_AS
StateProvinceName
nvarchar no 60 no (n/a) (n/a) Latin1_General_CI_AS
AddressKey
nvarchar no 500 no (n/a) (n/a) Latin1_General_CI_AS
CountryCode
nvarchar no 6 yes (n/a) (n/a) Latin1_General_CI_AS
Identity
Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
AddressID 1 1 0
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Addresses__IE1
clustered located on FileGroup0 PostCode
Addresses__PK
nonclustered, unique, primary key located on FileGroup0 AddressID
################
End SQL 2005 ####################
November 28, 2006 at 6:03 pm
Part 2 of the reply
On
SQL 2005
--------------------------------------------------------------------------------------------------------------------------------
us_english
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL
Server 2005 - 9.00.2153.00 (Intel X86)
May 8 2006 22
:41:28
Copyright
(c) 1988-2005 Microsoft Corporation
Enterprise Edition
on Windows NT 5.2 (Build 3790: Service Pack 1)
ftcatid
NAME PATH STATUS NUMBER_FULLTEXT_TABLES
----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------------------
6 cat_Addresses_Test O
:\FULL_TEXT\cat_Addresses_Test 0 1
7 cat_Addresses_AI O
:\FULL_TEXT\cat_Addresses_AI 0 1
TABLE_OWNER TABLE_NAME FULLTEXT_KEY_INDEX_NAME FULLTEXT_KEY_COLID FULLTEXT_INDEX_ACTIVE FULLTEXT_CATALOG_NAME
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ --------------------- --------------------------------------------------------------------------------------------------------------------------------
dbo _TEMP_ADDRESSES PK__TEMP_ADDRESSES 1 1 cat_Addresses_Test
dbo Addresses Addresses__PK 1 1 cat_Addresses_AI
TABLE_OWNER TABLE_ID TABLE_NAME FULLTEXT_COLUMN_NAME FULLTEXT_COLID FULLTEXT_BLOBTP_COLNAME FULLTEXT_BLOBTP_COLID FULLTEXT_LANGUAGE
-------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------- -----------------
dbo 475213539 _TEMP_ADDRESSES FullAddress 3
NULL NULL 1033
dbo 475213539 _TEMP_ADDRESSES PostCode 5
NULL NULL 1033
dbo 475213539 _TEMP_ADDRESSES LocalityName 6
NULL NULL 1033
dbo 475213539 _TEMP_ADDRESSES StateProvinceCode 7
NULL NULL 1033
dbo 475213539 _TEMP_ADDRESSES StateProvinceName 8
NULL NULL 1033
dbo 101575400 Addresses FullAddress 3
NULL NULL 1033
dbo 101575400 Addresses PostCode 5
NULL NULL 1033
dbo 101575400 Addresses LocalityName 6
NULL NULL 1033
dbo 101575400 Addresses StateProvinceCode 7
NULL NULL 1033
dbo 101575400 Addresses StateProvinceName 8
NULL NULL 1033
Name
Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
Addresses dbo
user table 2001-03-23 11:33:32.610
Column_name
Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
AddressID
int no 4 10 0 no (n/a) (n/a) NULL
FullAddress
nvarchar no 502 no (n/a) (n/a) Latin1_General_CI_AS
CountryID
int no 4 10 0 no (n/a) (n/a) NULL
PostCode
nvarchar no 22 no (n/a) (n/a) Latin1_General_CI_AS
LocalityName
nvarchar no 60 no (n/a) (n/a) Latin1_General_CI_AS
StateProvinceCode
nvarchar no 10 yes (n/a) (n/a) Latin1_General_CI_AS
StateProvinceName
nvarchar no 60 no (n/a) (n/a) Latin1_General_CI_AS
AddressKey
nvarchar no 500 no (n/a) (n/a) Latin1_General_CI_AS
CountryCode
nvarchar no 6 yes (n/a) (n/a) Latin1_General_CI_AS
Identity
Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
AddressID 1 1 0
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Addresses__IE1
clustered located on FileGroup0 PostCode
Addresses__PK
nonclustered, unique, primary key located on FileGroup0 AddressID
################
End SQL 2005 ####################
On
SQL 2000
--------------------------------------------------------------------------------------------------------------------------------
us_english
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL
Server 2000 - 8.00.2040 (Intel X86)
May 13 2005 18
:33:17
Copyright
(c) 1988-2003 Microsoft Corporation
Enterprise Edition
on Windows NT 5.2 (Build 3790: Service Pack 1)
ftcatid
NAME PATH STATUS NUMBER_FULLTEXT_TABLES
------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------------------
5 cat_Addresses I
:\FULL_TEXT\CI_InvProd 0 1
TABLE_OWNER TABLE_NAME FULLTEXT_KEY_INDEX_NAME FULLTEXT_KEY_COLID FULLTEXT_INDEX_ACTIVE FULLTEXT_CATALOG_NAME
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ --------------------- --------------------------------------------------------------------------------------------------------------------------------
dbo Addresses Addresses__PK 1 1 cat_Addresses
TABLE_OWNER TABLE_ID TABLE_NAME FULLTEXT_COLUMN_NAME FULLTEXT_COLID FULLTEXT_BLOBTP_COLNAME FULLTEXT_BLOBTP_COLID FULLTEXT_LANGUAGE
-------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------- -----------------
dbo 101575400 Addresses FullAddress 3
NULL NULL 1033
dbo 101575400 Addresses PostCode 5
NULL NULL 1033
dbo 101575400 Addresses LocalityName 6
NULL NULL 1033
dbo 101575400 Addresses StateProvinceCode 7
NULL NULL 1033
dbo 101575400 Addresses StateProvinceName 8
NULL NULL 1033
(
5 row(s) affected)
Name
Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
Addresses dbo
user table 2001-03-23 11:33:32.610
Column_name
Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
AddressID
int no 4 10 0 no (n/a) (n/a) NULL
FullAddress
nvarchar no 502 no (n/a) (n/a) Latin1_General_CI_AS
CountryID
int no 4 10 0 no (n/a) (n/a) NULL
PostCode
nvarchar no 22 no (n/a) (n/a) Latin1_General_CI_AS
LocalityName
nvarchar no 60 no (n/a) (n/a) Latin1_General_CI_AS
StateProvinceCode
nvarchar no 10 yes (n/a) (n/a) Latin1_General_CI_AS
StateProvinceName
nvarchar no 60 no (n/a) (n/a) Latin1_General_CI_AS
AddressKey
nvarchar no 500 no (n/a) (n/a) Latin1_General_CI_AS
CountryCode
nvarchar no 6 yes (n/a) (n/a) Latin1_General_CI_AS
Identity
Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
AddressID 1 1 0
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Addresses__IE3
clustered located on PRIMARY PostCode
Addresses__PK
nonclustered, unique, primary key located on FileGroup0 AddressID
November 28, 2006 at 8:02 pm
You're welcome, Bimal,
However, it seems you posted the SQL Server 2005 output twice. I need the SQL Server 2000 information to compare & contrast with the SQL 2005 FTS info. Can you post the output to the SQL script from the SQL 2000 server?
Thanks,
John
SQL Full Text Search Blog
http://jtkane.spaces.live.com/
John T. Kane
November 28, 2006 at 9:18 pm
Ah yes, sorry about it.
SQL 2000 OUTPUT
--------------------------------------------------------------------------------------------------------------------------------
us_english
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)
May 13 2005 18:33:17
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
ftcatid NAME PATH STATUS NUMBER_FULLTEXT_TABLES
------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------------------
5 cat_Addresses I:\FULL_TEXT\CI_InvProd 0 1
TABLE_OWNER TABLE_NAME FULLTEXT_KEY_INDEX_NAME FULLTEXT_KEY_COLID FULLTEXT_INDEX_ACTIVE FULLTEXT_CATALOG_NAME
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ --------------------- --------------------------------------------------------------------------------------------------------------------------------
dbo Addresses Addresses__PK 1 1 cat_Addresses
TABLE_OWNER TABLE_ID TABLE_NAME FULLTEXT_COLUMN_NAME FULLTEXT_COLID FULLTEXT_BLOBTP_COLNAME FULLTEXT_BLOBTP_COLID FULLTEXT_LANGUAGE
-------------------------------------------------------------------------------------------------------------------------------- ----------- -------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -------------- -------------------------------------------------------------------------------------------------------------------------------- --------------------- -----------------
dbo 101575400 Addresses FullAddress 3 NULL NULL 1033
dbo 101575400 Addresses PostCode 5 NULL NULL 1033
dbo 101575400 Addresses LocalityName 6 NULL NULL 1033
dbo 101575400 Addresses StateProvinceCode 7 NULL NULL 1033
dbo 101575400 Addresses StateProvinceName 8 NULL NULL 1033
(5 row(s) affected)
Name Owner Type Created_datetime
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------- -----------------------
Addresses dbo user table 2001-03-23 11:33:32.610
Column_name Type Computed Length Prec Scale Nullable TrimTrailingBlanks FixedLenNullInSource Collation
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ----------------------------------- ----------- ----- ----- ----------------------------------- ----------------------------------- ----------------------------------- --------------------------------------------------------------------------------------------------------------------------------
AddressID int no 4 10 0 no (n/a) (n/a) NULL
FullAddress nvarchar no 502 no (n/a) (n/a) Latin1_General_CI_AS
CountryID int no 4 10 0 no (n/a) (n/a) NULL
PostCode nvarchar no 22 no (n/a) (n/a) Latin1_General_CI_AS
LocalityName nvarchar no 60 no (n/a) (n/a) Latin1_General_CI_AS
StateProvinceCode nvarchar no 10 yes (n/a) (n/a) Latin1_General_CI_AS
StateProvinceName nvarchar no 60 no (n/a) (n/a) Latin1_General_CI_AS
AddressKey nvarchar no 500 no (n/a) (n/a) Latin1_General_CI_AS
CountryCode nvarchar no 6 yes (n/a) (n/a) Latin1_General_CI_AS
Identity Seed Increment Not For Replication
-------------------------------------------------------------------------------------------------------------------------------- --------------------------------------- --------------------------------------- -------------------
AddressID 1 1 0
index_name index_description index_keys
-------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Addresses__IE3 clustered located on PRIMARY PostCode
Addresses__PK nonclustered, unique, primary key located on FileGroup0 AddressID
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply