FULL TEXT SEARCH FAIL

well,
I had previous disscussions with john regarding the Full Text Failier with ignore words and he suggested to clean the data first before appying full text search and I have done that, it was breaking on where only ',' or '(' or ')' etc were in the field,
and was not breaking if there is any Numerical or alphabatical charactor is with them like 'A(' or ')1' etc was warking fine. so I have written an other procedure to clean the data and now it starts working until it found 'B.F.P.O 117' during full text se
arch, my cleansing procedure is removing all those rows where is some data in field without any Alphabatical or numerical charactor.
code is below
SET QUOTED_IDENTIFIER OFF
declare @.vTemp as varchar(22)
declare @.vTemp1 as varchar(60)
declare @.vTemp2 as varchar(12)
set @.vTemp2 = '"B.F.P.O 117"'
set @.vTemp1 = 'Head Teacher'
set @.vTemp = 'W Thomas'
SELECT * From contactTemp
where
--DIFFERENCE(fullname, @.vTemp) = 4
--and
--DIFFERENCE(address, '14 Marchmont Rd') = 4
freetext(full_name,@.vTemp)
and
freetext(Address,@.vTemp1)
AND contains(zip , @.vTemp2 )
well, now if i remove 7 from 'B.F.P.O 117' or I remove the space like 'B.F.P.O117' it works, i dont understand y this is happening
any idea will be much appriciated.
Ahsan
Ahsan,
I can undestand why it working when you remove sapce between 'B.F.P.O 117'.
That is because it thinks B.F.P.O as one word and 117 as other word and
probably thinks 117 being just a number is a ignored word.
BTW, what exact server is saying - "Query contains ignored words?"
"Ahsan" wrote:

> well,
> I had previous disscussions with john regarding the Full Text Failier with ignore words and he suggested to clean the data first before appying full text search and I have done that, it was breaking on where only ',' or '(' or ')' etc were in the field
, and was not breaking if there is any Numerical or alphabatical charactor is with them like 'A(' or ')1' etc was warking fine. so I have written an other procedure to clean the data and now it starts working until it found 'B.F.P.O 117' during full text
search, my cleansing procedure is removing all those rows where is some data in field without any Alphabatical or numerical charactor.
>
> code is below
> SET QUOTED_IDENTIFIER OFF
> declare @.vTemp as varchar(22)
> declare @.vTemp1 as varchar(60)
> declare @.vTemp2 as varchar(12)
> set @.vTemp2 = '"B.F.P.O 117"'
> set @.vTemp1 = 'Head Teacher'
> set @.vTemp = 'W Thomas'
>
> SELECT * From contactTemp
> where
> --DIFFERENCE(fullname, @.vTemp) = 4
> --and
> --DIFFERENCE(address, '14 Marchmont Rd') = 4
> freetext(full_name,@.vTemp)
> and
> freetext(Address,@.vTemp1)
> AND contains(zip , @.vTemp2 )
>
> well, now if i remove 7 from 'B.F.P.O 117' or I remove the space like 'B.F.P.O117' it works, i dont understand y this is happening
> any idea will be much appriciated.
> Ahsan
>

FULL TEXT SEARCH FAIL

well,
I had previous disscussions with john regarding the Full Text Failier with ignore words and he suggested to clean the data first before appying full text search and I have done that, it was breaking on where only ',' or '(' or ')' etc were in the field, and was not breaking if there is any Numerical or alphabatical charactor is with them like 'A(' or ')1' etc was warking fine. so I have written an other procedure to clean the data and now it starts working until it found 'B.F.P.O 117' during full text search, my cleansing procedure is removing all those rows where is some data in field without any Alphabatical or numerical charactor.
code is below
SET QUOTED_IDENTIFIER OFF
declare @.vTemp as varchar(22)
declare @.vTemp1 as varchar(60)
declare @.vTemp2 as varchar(12)
set @.vTemp2 = '"B.F.P.O 117"'
set @.vTemp1 = 'Head Teacher'
set @.vTemp = 'W Thomas'
SELECT * From contactTemp
where
--DIFFERENCE(fullname, @.vTemp) = 4
--and
--DIFFERENCE(address, '14 Marchmont Rd') = 4
freetext(full_name,@.vTemp)
and
freetext(Address,@.vTemp1)
AND contains(zip , @.vTemp2 )
well, now if i remove 7 from 'B.F.P.O 117' or I remove the space like 'B.F.P.O117' it works, i dont understand y this is happening
any idea will be much appriciated.
AhsanAhsan,
I can undestand why it working when you remove sapce between 'B.F.P.O 117'.
That is because it thinks B.F.P.O as one word and 117 as other word and
probably thinks 117 being just a number is a ignored word.
BTW, what exact server is saying - "Query contains ignored words?"
"Ahsan" wrote:
> well,
> I had previous disscussions with john regarding the Full Text Failier with ignore words and he suggested to clean the data first before appying full text search and I have done that, it was breaking on where only ',' or '(' or ')' etc were in the field, and was not breaking if there is any Numerical or alphabatical charactor is with them like 'A(' or ')1' etc was warking fine. so I have written an other procedure to clean the data and now it starts working until it found 'B.F.P.O 117' during full text search, my cleansing procedure is removing all those rows where is some data in field without any Alphabatical or numerical charactor.
>
> code is below
> SET QUOTED_IDENTIFIER OFF
> declare @.vTemp as varchar(22)
> declare @.vTemp1 as varchar(60)
> declare @.vTemp2 as varchar(12)
> set @.vTemp2 = '"B.F.P.O 117"'
> set @.vTemp1 = 'Head Teacher'
> set @.vTemp = 'W Thomas'
>
> SELECT * From contactTemp
> where
> --DIFFERENCE(fullname, @.vTemp) = 4
> --and
> --DIFFERENCE(address, '14 Marchmont Rd') = 4
> freetext(full_name,@.vTemp)
> and
> freetext(Address,@.vTemp1)
> AND contains(zip , @.vTemp2 )
>
> well, now if i remove 7 from 'B.F.P.O 117' or I remove the space like 'B.F.P.O117' it works, i dont understand y this is happening
> any idea will be much appriciated.
> Ahsan
>

FULL TEXT SEARCH FAIL

well,
I had previous disscussions with john regarding the Full Text Failier with i
gnore words and he suggested to clean the data first before appying full tex
t search and I have done that, it was breaking on where only ',' or '(' or
')' etc were in the field,
and was not breaking if there is any Numerical or alphabatical charactor is
with them like 'A(' or ')1' etc was warking fine. so I have written an other
procedure to clean the data and now it starts working until it found 'B.F.P
.O 117' during full text se
arch, my cleansing procedure is removing all those rows where is some data i
n field without any Alphabatical or numerical charactor.
code is below
SET QUOTED_IDENTIFIER OFF
declare @.vTemp as varchar(22)
declare @.vTemp1 as varchar(60)
declare @.vTemp2 as varchar(12)
set @.vTemp2 = '"B.F.P.O 117"'
set @.vTemp1 = 'Head Teacher'
set @.vTemp = 'W Thomas'
SELECT * From contactTemp
where
--DIFFERENCE(fullname, @.vTemp) = 4
--and
--DIFFERENCE(address, '14 Marchmont Rd') = 4
freetext(full_name,@.vTemp)
and
freetext(Address,@.vTemp1)
AND contains(zip , @.vTemp2 )
well, now if i remove 7 from 'B.F.P.O 117' or I remove the space like 'B.F.P
.O117' it works, i dont understand y this is happening
any idea will be much appriciated.
AhsanAhsan,
I can undestand why it working when you remove sapce between 'B.F.P.O 117'.
That is because it thinks B.F.P.O as one word and 117 as other word and
probably thinks 117 being just a number is a ignored word.
BTW, what exact server is saying - "Query contains ignored words?"
"Ahsan" wrote:

> well,
> I had previous disscussions with john regarding the Full Text Failier with ignore
words and he suggested to clean the data first before appying full text search and I
have done that, it was breaking on where only ',' or '(' or ')' etc were in the fi
eld
, and was not breaking if there is any Numerical or alphabatical charactor i
s with them like 'A(' or ')1' etc was warking fine. so I have written an oth
er procedure to clean the data and now it starts working until it found 'B.F
.P.O 117' during full text
search, my cleansing procedure is removing all those rows where is some data in field withou
t any Alphabatical or numerical charactor.
>
> code is below
> SET QUOTED_IDENTIFIER OFF
> declare @.vTemp as varchar(22)
> declare @.vTemp1 as varchar(60)
> declare @.vTemp2 as varchar(12)
> set @.vTemp2 = '"B.F.P.O 117"'
> set @.vTemp1 = 'Head Teacher'
> set @.vTemp = 'W Thomas'
>
> SELECT * From contactTemp
> where
> --DIFFERENCE(fullname, @.vTemp) = 4
> --and
> --DIFFERENCE(address, '14 Marchmont Rd') = 4
> freetext(full_name,@.vTemp)
> and
> freetext(Address,@.vTemp1)
> AND contains(zip , @.vTemp2 )
>
> well, now if i remove 7 from 'B.F.P.O 117' or I remove the space like 'B.F
.P.O117' it works, i dont understand y this is happening
> any idea will be much appriciated.
> Ahsan
>sql

Full or Diff backup impact on Log size?

I have a question regarding FUll and differential backup.

We we take full or diff back up, does it create lot of logs ie. Does full or diff backup has any impact on log size?

Thanks

No, not in my experience.|||The backup itself will not add much to the log, but it will hold up log truncation for the duration of the backup so that if there is a lot of other activity being logged by other users during the backujp, the log can become increasingly full. Once the backup is done, the log should be able to truncate as usual (for SIMPLE recovery mode.)|||Thanks for the replies.
So taking full or diff backup does not create additional logs?. It will be just the logs of incoming transactions (not any additional logs because of full or diff backup)?

Thanks
|||That's correct.