hey Raj

getting same error.Got any solution

Any one of the values that you are concatenating might be null.

put a isnull check of that value.

isnull(null_value,'')

Not much option of overcoming the sort operation unitll order by is removed,,,

one way you can try creating indexed view,,,,

have you tried

dbcc shrinkfile(<'logfilename'>)

works better in simple recovery mode

check for following things:

tuning HaversineDistanceKm fn

check for missing or non used indexes

check for statistics

The use of isnull function should avoid the use if indexes..

use of functions on the query predicates avoids the use of indexes

also put rowlock on the table from which data is deleted

put nolock on the tableB (referenced table)

facticatech (1/12/2011)

---

I have set of columns (more than 10) and need to update them to 0 if it is null.

for eg: update table set column1=0 where column1 is null

update...

Rowlock will help till some extent (till threshold reached)....

After the threshold number of locks gets acquired the rowlock gets escalated to table level lock to optimally use the resources.....

As per...

yes

in topic you have specified select 'x'

so i think you wanted to know for select 'x' from tablename

the above query will return char x for all the records in the...

photonicman (1/5/2011)

---

Okay, how about adding a column to this data to count the first, second, third, etc occurrence of duplicate PA_EnterpriseID's in column 1 - Placing the count in a...

As Specified by the Gila,,the two queries won't fetch the same results,,,

In general checking for nullablilty for parameter would be better than checking for nullablilty for the column.

Try out this on as well..

SELECT name,

address

FROM tab tab1

WHERE EXISTS(SELECT tab2.address

...