this may be hard to find out, depending on the traces you are running.

Maybe even a log-analyser kind of application can dig into your msdb-logfiles to find out, if possible,...

Peter Gadsby (10/29/2007)

---

Thanks ALZDBA Not sure what the benefits of sorting the data by the fields in the clustered index, because if the clustered index is not dropped the data...

just my 2ct.

Don't remove the clustered index ! drop all nci and then truncate the table.

Load the data sorted according to the clustered index definition. This way , your data...

Did you start with a "select * " to see what's the cause of this error ?

just another thought ...

avoid FREETEXT !

Freetext <> like !

Maybe a like predicate serves you better.

Check BOL !

WHERE A.City_Name like '%New York%' and A.state = 'NY')

AND ( B.Business_Name...

Just my 2 ct.

I'd first convert the where ... in (select .. ) or ... in ( select ...)

to correlated subqueries lik :

WHERE A.City_Name like '%New York%'

and...

have a look at the new pivot methode:

Pivot table for Microsoft SQL Server

http://www.sqlservercentral.com/articles/Advanced+Querying/pivottableformicrosoftsqlserver/2434/

http://www.sqlservercentral.com/articles/Development/2734/

http://www.sqlservercentral.com/redirect/articles/2791/

you could also use the new "intersect" and "except" clauses to get mutual of different rows in a set ( unjoined ).

http://msdn2.microsoft.com/en-us/library/ms188055.aspx

this would take a tripple join

select ...

from computers C

inner join computers_to_components_relations CCR

on C.ID = CCR.COMPUTER_ID

inner join components Cmp

on CCR.COMPONENT_ID =...

Let us know if it got an A+:w00t:

HTH

regarding the unavailable files .... if you encounter invalid urls, contact the webmaster. The site has been restyled and suffers some issues of this kind.:ermm:

I've just contaced the webmaster. Normaly...

Oops SQL7-2000 forum ..... offcouse CTE's will not be available for you, nor will outerapply :blush:

CREATE FUNCTION utvf_getDateList_2000 ( @startDate datetime, @endDate DATETIME)

RETURNS @tvfResult TABLE ( effective_date DATETIME NOT NULL...

IMO one should always work with deterministic data, meaning always specify an end date (even if it is way up in the future).

It avoids handling a NULL enddate and urges...

KISS principle :

CREATE PROC spc_Currencyconvertor

@FromCurrencyCode CHAR(3),

@ToCurrencyCode CHAR(3),

@Amount MONEY ,

@CurrencyRateDate DATETIME ,

@ConvertedValue MONEY OUTPUT

AS

BEGIN

SET NOCOUNT ON

IF @CurrencyRateDate IS NULL

BEGIN

SET...

Recursive Queries in SQL:1999 and SQL Server 2005

http://www.sqlservercentral.com/articles/SQL+Server+2005+-+TSQL/recursivequeriesinsql1999andsqlserver2005/1846/

With nice tests ...

CTE Performance

http://www.sqlservercentral.com/articles/2926/