Re: Conditional full-text indexing possible in 2000?

Hilary Cotter wrote:

You do full-text index views in SQL 2005 which could incorporate this
condition. It is not possible to do this in SQL 2000 unless you partition
the data which matches your condition into a separate table.


Hello Hillary, thank you very much for your reply :)

The partition scheme you describe seems to be exactly the approach used at
the moment. The server will, among other tasks, be backing a TYPO3
installation, and at the moment it seems this actually won't run on MS SQL
2000. So now we have two good arguments for upgrading.

We have a 2005 Standard license, so we're trying that out to see if it'll
fit the bill.

Thanks again for your help :)

Daniel
.

Relevant Pages

  • Re: SQL Server 2005 Express as a Data Mart environment
    ... I'm not sure if there are any limitations with SQL Express with respect to ... meter with 60-170k rows each with 3.5mil rows total. ... each partition. ... 15MinuteInterval TinyInt ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Merge join performs really slow
    ... You can remove the join from the SQL statement but do so at your own risk. ... or you could load the partition through a view (which is my ... > join hint - with a loop join strategy. ...
    (microsoft.public.sqlserver.olap)
  • Re: Getting Started - RAID, Multiple Instances, SQL 2000-2005 . . .
    ... SQL 2000 Std. ... Data and Logs on RAID 5 partition ... Planning to put OS on RAID 1 partition, logs on different RAID 1 partition, ...
    (microsoft.public.sqlserver.setup)
  • Re: MSAS 2000 Read Time (64 bit) ; DB: DB2
    ... >> I already have the advanced filter set to each of the partition slices. ... >> I want to correct some of my MSAS Read time stats that I mentioned in my ... >> We are using IBM OLEDB Provider for DB2 shipped with MSAS. ... I think the first thing that I would do is to get the SQL ...
    (microsoft.public.sqlserver.olap)
  • Re: MSAS 2000 Read Time (64 bit) ; DB: DB2
    ... SQL BI Product Unit ... > I already have the advanced filter set to each of the partition slices. ... > I want to correct some of my MSAS Read time stats that I mentioned in my ... > close to 150 K rows per minute from DB2. ...
    (microsoft.public.sqlserver.olap)
Loading