Must you use CONTAINSTABLE (because you need the rank), or can you use Contains() like this:

SELECT a.*

  FROM tlogdata a

 WHERE Contains(message_data, ' "search" ')

Also, how many rows do you get when...

Can you post your query?  Are you using a CONTAINS() clause by itself, or with other conditions?  If other columns are involved, you may need to create additional indexes on...

I think a previous poster meant:

replace

AND

(convert(numeric(5,2),

convert(float, lbd.total_training_seconds) /

convert(float, tit.tit_wfm)) >= .80)

with

AND CASE tit.tit_wfm

      WHEN 0 THEN 0 -- to include, or 1 to exclude

      ELSE...

In Simple recovery mode, the LOGICAL log is truncated regularly whenever a checkpoint is executed.  The physical log file is NOT shrunk.  So if a very large transaction runs, causing...

Yes..you're correct. It always helps to read the problem carefully! 

Maybe this will help:

ALTER TABLE MyTable DISABLE TRIGGER ALL

-- do you update here

ALTER TABLE MyTable ENABLE TRIGGER ALL

Something along these lines might work:

SELECT Tours.tourID

     , Tours.tourDate

     , Tours.tourStatus

     , Tours.tourDestination

     , Tours.tourDuration

     , Tours.tourPrice

     , tourDetailsCat.tourDetCatName

  FROM TourDetails

 INNER JOIN Tours ON TourDetails.fk_tourID =...

You have a design problem. How is the ticketNumber row inserted? If you need to update a column after an insert, you may need to wrap it in a transaction.  It looks...

How about this (assuming a case-insensative collation):

select *

  from daysoftheweek

 where CharIndex(day, 'i was born on Friday in may') > 0

or, if case-sensative

select *

  from daysoftheweek

 where CharIndex(Lower(day), Lower('i was born on...

You could try using PreviewPage.MoveFirst after the first loop to reset the pointer back to the beginning of the file.

Another method is to use a bookmark (particulary useful...

Try this:

SELECT 'Vendor: '+ vendor + '/n '

     + 'Check number: ' + [check] + '/n '

     + 'Amount: $' + CONVERT(varchar(15), amount, 1) + '/n '

    ...

"It's obvious that author just used not the same DATEFIRST settings on his server as you."

Actually, the date was specified as '2002-02-29', which is invalid no...

If you use SELECT Convert(varchar(8), GetDate(), 112), which returns the date in YYYYMMDD format, you avoid any locality issues.

However, in my tests, SELECT CAST(FLOOR(CAST(@x AS FLOAT)) AS DATETIME) runs almost...

Are you sure mat.[material__code] is of type varchar and that it doesn't contain trailing blanks? You might have to trim mat.[material__code] before appending the '%':

SELECT     item.[search description], mat.[material__code]

FROM         [Item] item INNER...

It must be a data issue, such as:

1. The Calendar table doesn't include today's date

2. The JOIN alone doesn't return any data, in which case the Calendar table once again...