Re: Weight returning unexpected results

John, thanks for your reply. I have 300,000+ rows in the address table,
although now I just ran the same query and I'm getting the results I
was expecting. I'm pretty sure it was re-populating the index when I
was doing my initial testing, so perhaps SQL Server updates statistics
after each population that it needs to determine the rank?

I'll see if I can find anything in the BOL, but it does seem much
better now.

.

Relevant Pages

  • performance question/multiple keys
    ... The table I'm using has full-text columns and also a date column thats ... If I do a query on a date range and the full-text column does SQL ... John ... Prev by Date: ...
    (microsoft.public.sqlserver.fulltext)
  • Using AND and OR together in sql
    ... I've tried to make a search an AND OR query ... record with name of John or Paul of age 32 and simply name of John or Paul. ... Prev by Date: ...
    (microsoft.public.vb.general.discussion)
  • extacting first name from a field
    ... the first name in a query. ... So if I have John R. I only want to extract John. ... Prev by Date: ...
    (microsoft.public.access.gettingstarted)
  • Count unique values
    ... My Access-97 table looks like this: ... I'd like to make a query which gives me a new table with all unique values ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Still Stuck on Alpha Numerics
    ... >Hi John, I had a thought. ... Could it be that the null values are affecting the ... Prev by Date: ...
    (microsoft.public.access.tablesdbdesign)
Loading