Re: Are Population Schedules required?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hello geek-y-guy,

Historically in SQL 2000, populations could impact querying (errors occurring) so you may have wanted to do delay the population.

If you have lots of changes you may still want to delay population to avoid the performance hit of population and querying


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


Thanks Hilary!

So, just for my edification, what are population schedules for? For
very large cats & datasets where you would NOT want it automatically
updating, but would want to schedule repopulation say once daily at 3
am?



.

Relevant Pages

  • Re: Indexing delay for one row.
    ... script and WAITFOR and varying the delay from 1 to 18 seconds. ... could you confirm your exact version of SQL Server that you are seeing ... It is possible that a change was made to the pooling frequence under SP3 to ... exec sp_fulltext_table 'FTSTable','create','FTSCatalog','FTSTable_IDX' ...
    (microsoft.public.sqlserver.fulltext)
  • Re: SQL access very slow in Paradox 9 HELP!
    ... the 200 m/s delay that now exists by default under Windows 2003. ... other than being slightly slow due to the nature of the SQL box also being ... a File / Print server. ... This box is Windows 2000. ...
    (comp.databases.paradox)
  • Re: flashback question
    ... The only solution is to wait at least 5 minutes after the table is created before attempting to use flashback in 9.2. ... there is a solution to avoid this delay in 9iR2 as well. ... Event didn't work by sql driven flashback, but it works as expected by ... Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production With the Partitioning, OLAP and Oracle Data Mining options ...
    (comp.databases.oracle.server)
  • Re: Delaying consuming multiple xml messages
    ... I think the problem is more in your database, SQL statements and SP's ... >> If you are going to use the delay shape or delay consuming in another way, ... >> orchestration at a time where the orchestration is not ready to receive it. ...
    (microsoft.public.biztalk.general)