FT Catalog "optimise" or "populate" differences
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
Hi,
In SQL 2005 does anyone know what the difference between a full text
catalogue "optimize" and a "populate" is? In 2000 I think there was only
populate.
It seems you can't schedule a normal "populate" in 2005 - only an
"optimise".
Nick...
.
Relevant Pages
- Re: Scripting conditional list box
... the drop down boxwon't populate. ... Dim SQL as string ... SQL = "SELECT ApptTime FROM AppointmentTimes WHERE ApptTime not in ... except that you called the query "Time". ... (microsoft.public.access.formscoding) - Re: Re: Inserting large amounts of data
... > I'm using DTS to populate a staging table with raw streams of data (a ... I thought about imbedding the SQL ... Doing the substringing in T-SQL is not the ... (comp.databases.ms-sqlserver) - Re: Populating date into SQL
... datetime field in SQL ... Dim trans As SqlClient.SqlTransaction 'Transaction object ... 'Populate sql ... insertCMD = String.Formatvalues ... (microsoft.public.dotnet.languages.vb) - Re: Please display the table faster in the datagrid
... > Thanks Dmitriy, I did find some 3rd party tools but I'm not ready to ... > recommend purchasing them yet. ... > VFP table would I be able to use mySQLCommand.ExecuteNonQuery() with a SQL ... You can't populate a grid with 60 million records (which ... (microsoft.public.vb.database) - IIS 6 Security/Authentication Problem?
... One of the .asp pages in this sub-web is set to Integrated Windows ... Authentication so that I can pull the users username using ... This page also makes a databse call to SQL2K to populate some drop down ... which to logon to SQL. ... (microsoft.public.inetserver.iis) |
|