SELECTing a range from the results
Tue, 15 Jul 2008 20:32:17 -0400
I would like to create a SELECT statement that returns a certain range of
the results that a WHERE clause returns. For example, if the WHERE clause
would return 75 records, I want a way to have the SELECT statement return
the second 10 records, or the third 10 records, etc. I know how to use the
TOP(x) claus ...
|
Full text index not created on varbinary(max) - sql 2008
Tue, 15 Jul 2008 06:05:02 -0700
Hi
Full text query on varbinary(max) column is not returning results, as the
index is not populated.
Some configuration error - can't figure out what.
FDHost process has no issues
The log shows this - Informational: Full-text Auto population completed for
table or indexed view '<name>' (table or indexed ...
|
Incorrect RANK results returned
Tue, 15 Jul 2008 09:52:39 +0100
Morning all,
I'm having problems with my FTS rankings on our SQL2005 database and I'm a
bit stumped as where to start looking at what the the problem might be.
The simplified SQL is as follows:
---------------------------------------------------------------------------------------------
DECLARE @SEARCH n ...
|
Boolean queries not working over the all columns in the index
Thu, 10 Jul 2008 04:06:00 -0700
If I execute a query such as this one, I get back records that contain
"DaVinci" in AddressLine1 column and "Kirkland" in the City column:
select ft.id, ft.name, Line1, Line2, Line3, line4, city, county
from company as ft
inner join containstable(company, * , '"barnes nobl*"') as [key]
on ft.id = [key].[key] ...
|
There is no enough storage space available... error
Tue, 8 Jul 2008 16:08:45 +0200
Hi friends, and sorry for my english.
I have a SQL Server 2000 with severals databases which hold more than 210
full text catalogs.
Recently, after create the last 3 DBs with 10 catalogs each, when the
Mssearch service populates the catalogs, I am getting the following error in
the application viewer: "C ...
|
Full text catalog does not get associated with the specified FileG
Thu, 3 Jul 2008 22:05:00 -0700
Hi
I am trying to create a full text catalog on sql server 2008 feb CTP. The
create command executes successfully, however, the catalog does not get
associated with the filegroup specified in the create command. Trying to open
properties of the catalog results in error that filegroup property is not
avail ...
|
The Gatherer object in project <SQLServer SQLxxxxxxx>cannot be
initialized. Error:0 - The operation complete successfully
Wed, 2 Jul 2008 05:57:12 -0700 (PDT)
Hi Team,
Configuration:
SQL Server 2000 SP4
Clustered - Active / Passive
Windows 2000 SP4
Issue:
Full Text is not working when there is a cluster failover to the
passive node2 from active node1. When the cluster is again switched
back to the original node1, full text search is working properly!
Error ...
|
|
|
Help needed with SELECT query
Wed, 2 Jul 2008 11:45:54 +0200
Hi,
Don't know if this is the right forum...
Anyways I need some help with constructing a SELECT query:
The table below is an example:
WONUMBER PARENT AMOUNT HASCHILDREN
===========================================
1234 NULL 10 Y
2345 ...
|
??????View????????????
Wed, 2 Jul 2008 09:13:31 +0800
Dears£¬
²»ÖªµÀÊÇ·ñ¿ÉÒÔ¶ÔView½¨Á¢È«ÎļìË÷Ë÷Òý£¿
Èç¹û¿ÉÒÔ£¬Ôõô½¨Á¢£¿
лл¸÷λ´óÏÀ£¡
--
Best regards,
YuQ
...
|
Retrieving words found in text
Mon, 30 Jun 2008 11:12:01 -0700
Hi,
Is there a way to get a list (programmatically) of the words that SQL Server
expands a userâ??s search word to for inflectional search?
Example:
1. User searches â??runâ?
2. Inflectional search finds a document with the word â??ranâ? (different tense)
3. I want to display the word that was actual f ...
|
