Re: Conditional full-text indexing possible in 2000?

Hello Daniel,

Indexed views will store a complete copy of the data.

Standard edition doesn't do partitioning you will need to use a partitioned view which adds a level of complexity because of the restrictions on their design. You could add the extra column as a token so that you don't get those rows back from the full text search i.e.

select * from containstable (yourtable, yourcolumn,'(IWantThisValue AND ThisValue) AND NOT ISDELETED'

so when you update your isdeleted flag to 1 you add ISDELETED to the column being full text indexed


Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


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 Page File
    ... Perhaps Dan was referring to tempdb? ... Tibor Karaszi, SQL Server MVP ... page file is best located on it's own RAID 1 partition or on the log file ...
    (microsoft.public.sqlserver.setup)
  • Re: Process Cube : Refresh Data or Full Process ?
    ... But I use Standard Edition while Partitioning and Linked cubed only ... After all currency rates change every day. ... to partition your cube: one partition for data in the analysis currency and ...
    (microsoft.public.sqlserver.olap)
  • Windows 2008 Server (Standard Edition) auf 1 HDD?
    ... kann man Wk28 Standard Edition so installieren, dass er nur 1 Partition braucht? ... Die Platten jenseits der Systempartition waren aber eigentlich als Datenplatten gedacht. ...
    (microsoft.public.de.german.windows.server.setup)
  • urgent:Repeat error in reading data after every process of cube.
    ... We have cube of about 750 million rows in fact table. ... I am using std edition on X64 machine. ... since its standard edition I can create 3 partitions. ... each partition of 200 million rows. ...
    (microsoft.public.sqlserver.olap)
  • Puzzling Disk Space Consumption - URGENT ASSISTANCE
    ... I have a SBS 2003 (standard edition) system installed and running for 3 ... months and 12 active users. ... log files configured on install to direct to D: partition. ... What could be consuming all the hard drive space? ...
    (microsoft.public.windows.server.sbs)