How I can do Set Minus operation?

I would like to perform the Set Minus operation on two
table containg same structure.
For Example
Table1(Field1, Field2) having rows like (1,1),(2,1),(3,2),
(4,2).
Table2(Field1, Field2) having rows like (1,1),(3,2)
When I perfom Set Minus Operation on like Table1-Table2.
It should generate the resultant rows like (2,1) and (4,2)
in output.
I would like to perform this type of operation with SQL
Server.SELECT T1.*
FROM Table1 AS T1
LEFT JOIN Table2 AS T2
ON T1.col1 = T2.col1 AND T1.col2 = T2.col2
WHERE T2.col1 IS NULL
--
David Portas
--
Please reply only to the newsgroup
--|||The solutions works if there a no NULLS in the T2.col1.
Personaly (but this is a preference) I would use a not exists for a minus
operation.
Select * form T1 Where not exists (Select * from T2 where T1.pk = T2.pk)
The compare on pk is for all fields belonging to the primairy key.
When not using a pk, be carefull about NULLs (NULL = NULL evaluates
to false).
If there are potentially more matches the exists clause could work faster,
because it has only to evaluate one existence and can stop there.
ben brugman.
"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:Oj1JylDfDHA.3268@.tk2msftngp13.phx.gbl...
> SELECT T1.*
> FROM Table1 AS T1
> LEFT JOIN Table2 AS T2
> ON T1.col1 = T2.col1 AND T1.col2 = T2.col2
> WHERE T2.col1 IS NULL
> --
> David Portas
> --
> Please reply only to the newsgroup
> --
>

how good is Fast Text Search

Will Fast Text Search scale and perform well on large data? Is anybody
successful with it in a big way? Who?
Thanks,
TI assume you mean, "Full Text Search"? It can be made to scale, yes--I'm
aware of some massive web sites that are using it. That said, to make it
scale in certain scenarios you need to use some tricks. I recommend reading
the following:
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
> Will Fast Text Search scale and perform well on large data? Is anybody
> successful with it in a big way? Who?
> Thanks,
> T
>|||If you do mean Fast Text Search (http://www.fastsearch.com/) and not SQL
FTS, it is extremely fast but requires an index which is at least the same
size of the data you are indexing.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
> Will Fast Text Search scale and perform well on large data? Is anybody
> successful with it in a big way? Who?
> Thanks,
> T
>|||I just took a quick glance at the web site, and it looks like it doesn't
work inside of SQL Server? If that is the case, why not just use Lucene?
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%239qunrCuHHA.768@.TK2MSFTNGP04.phx.gbl...
> If you do mean Fast Text Search (http://www.fastsearch.com/) and not SQL
> FTS, it is extremely fast but requires an index which is at least the same
> size of the data you are indexing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
> news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
>> Will Fast Text Search scale and perform well on large data? Is anybody
>> successful with it in a big way? Who?
>> Thanks,
>> T
>|||FAST is faster than Lucene. The support for FAST is better than lucene, well
let me rephrase that, you have to pay for support for FAST, whereas with
lucene its free, and you get what you pay for.
So if you need speed (like acoona.com), you might want to use FAST. If you
want to do things on the cheap (like technorati) use lucene.
As you point out neither FAST nor lucene are integrated into SQL Server so
you have to do some work to get them to index database content.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
news:%23G7PhtCuHHA.668@.TK2MSFTNGP05.phx.gbl...
>I just took a quick glance at the web site, and it looks like it doesn't
>work inside of SQL Server? If that is the case, why not just use Lucene?
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%239qunrCuHHA.768@.TK2MSFTNGP04.phx.gbl...
>> If you do mean Fast Text Search (http://www.fastsearch.com/) and not SQL
>> FTS, it is extremely fast but requires an index which is at least the
>> same size of the data you are indexing.
>> --
>> Hilary Cotter
>> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602.html
>> Looking for a FAQ on Indexing Services/SQL FTS
>> http://www.indexserverfaq.com
>> "Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
>> news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
>> Will Fast Text Search scale and perform well on large data? Is anybody
>> successful with it in a big way? Who?
>> Thanks,
>> T
>>
>|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OFasZ8EuHHA.4476@.TK2MSFTNGP03.phx.gbl...
> FAST is faster than Lucene. The support for FAST is better than lucene,
> well
Wikipedia uses Lucene. Fast enough for the number 10 web site in the US ==probably fast enough for me :)
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220

how good is Fast Text Search

Will Fast Text Search scale and perform well on large data? Is anybody
successful with it in a big way? Who?
Thanks,
T
I assume you mean, "Full Text Search"? It can be made to scale, yes--I'm
aware of some massive web sites that are using it. That said, to make it
scale in certain scenarios you need to use some tricks. I recommend reading
the following:
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/ftslesld.mspx

Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
> Will Fast Text Search scale and perform well on large data? Is anybody
> successful with it in a big way? Who?
> Thanks,
> T
>
|||If you do mean Fast Text Search (http://www.fastsearch.com/) and not SQL
FTS, it is extremely fast but requires an index which is at least the same
size of the data you are indexing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
> Will Fast Text Search scale and perform well on large data? Is anybody
> successful with it in a big way? Who?
> Thanks,
> T
>
|||I just took a quick glance at the web site, and it looks like it doesn't
work inside of SQL Server? If that is the case, why not just use Lucene?

Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%239qunrCuHHA.768@.TK2MSFTNGP04.phx.gbl...
> If you do mean Fast Text Search (http://www.fastsearch.com/) and not SQL
> FTS, it is extremely fast but requires an index which is at least the same
> size of the data you are indexing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
> news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
>
|||FAST is faster than Lucene. The support for FAST is better than lucene, well
let me rephrase that, you have to pay for support for FAST, whereas with
lucene its free, and you get what you pay for.
So if you need speed (like acoona.com), you might want to use FAST. If you
want to do things on the cheap (like technorati) use lucene.
As you point out neither FAST nor lucene are integrated into SQL Server so
you have to do some work to get them to index database content.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
news:%23G7PhtCuHHA.668@.TK2MSFTNGP05.phx.gbl...
>I just took a quick glance at the web site, and it looks like it doesn't
>work inside of SQL Server? If that is the case, why not just use Lucene?
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%239qunrCuHHA.768@.TK2MSFTNGP04.phx.gbl...
>
|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OFasZ8EuHHA.4476@.TK2MSFTNGP03.phx.gbl...
> FAST is faster than Lucene. The support for FAST is better than lucene,
> well
Wikipedia uses Lucene. Fast enough for the number 10 web site in the US ==
probably fast enough for me

Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220

how good is Fast Text Search

Will Fast Text Search scale and perform well on large data? Is anybody
successful with it in a big way? Who?
Thanks,
TI assume you mean, "Full Text Search"? It can be made to scale, yes--I'm
aware of some massive web sites that are using it. That said, to make it
scale in certain scenarios you need to use some tricks. I recommend reading
the following:
http://www.microsoft.com/technet/pr...e/ftslesld.mspx
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
> Will Fast Text Search scale and perform well on large data? Is anybody
> successful with it in a big way? Who?
> Thanks,
> T
>|||If you do mean Fast Text Search (http://www.fastsearch.com/) and not SQL
FTS, it is extremely fast but requires an index which is at least the same
size of the data you are indexing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
> Will Fast Text Search scale and perform well on large data? Is anybody
> successful with it in a big way? Who?
> Thanks,
> T
>|||I just took a quick glance at the web site, and it looks like it doesn't
work inside of SQL Server? If that is the case, why not just use Lucene?
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%239qunrCuHHA.768@.TK2MSFTNGP04.phx.gbl...
> If you do mean Fast Text Search (http://www.fastsearch.com/) and not SQL
> FTS, it is extremely fast but requires an index which is at least the same
> size of the data you are indexing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
> news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
>|||FAST is faster than Lucene. The support for FAST is better than lucene, well
let me rephrase that, you have to pay for support for FAST, whereas with
lucene its free, and you get what you pay for.
So if you need speed (like acoona.com), you might want to use FAST. If you
want to do things on the cheap (like technorati) use lucene.
As you point out neither FAST nor lucene are integrated into SQL Server so
you have to do some work to get them to index database content.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
news:%23G7PhtCuHHA.668@.TK2MSFTNGP05.phx.gbl...
>I just took a quick glance at the web site, and it looks like it doesn't
>work inside of SQL Server? If that is the case, why not just use Lucene?
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%239qunrCuHHA.768@.TK2MSFTNGP04.phx.gbl...
>|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OFasZ8EuHHA.4476@.TK2MSFTNGP03.phx.gbl...
> FAST is faster than Lucene. The support for FAST is better than lucene,
> well
Wikipedia uses Lucene. Fast enough for the number 10 web site in the US ==
probably fast enough for me
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220