Yeah, I too feel the same, Clustering the Column2 might not be the right choice for my requirement, what I did is I created the Covering Index with the ON...

@Gail,

I am Sorry, just I am going to try your Idea, I was little bit busy (sorry to say this...) with daily task, I would let you know how...

As far as I understood, your table should be implemented with a Primary Key (Clustered preferrable), because then only Query Analyzer could sort the Data in a faster way, then...

Hi,

Yes, you have mentioned it in the SELECT Statement, but what's the reason is, it is simply a namespace error,

Check for the column Name in the MainTable.

Thanks,

Prabhu

thanks for your curiousness, I think it is around 1.something, (comparitively much better than earlier)

Hi G.F,

yes,

it works as Charm..

Thanks,

Prabhu

multiple identifier "exhibitor.dbo.maintable.Mid"

you could have used this Column "Mid" from the table "MainTable" from the Exhibitor DB,

the SQL tells you that, particular column you are trying to use is...

NOLOCK = gives you data May be Committed or Uncommitted,

READPAST = Does not lock, but gives you only committed data

Yes,

DECIMAL(10,5) would be the good choice, as "10" stands for the Total Integer count allowed and the "5" stands for the scale where you can enter the max of .99999

but...

Correction:

It is Quite Good to use NOLOCK, but make sure you are NOTexpecting Data Consistency.

As the NOLOCK would ridoff the Lockings on the Situation, and as per your statement

"Not Used in Any REPORTING"

It is Quite Good to use NOLOCK, but make sure you are...

please find the attachment

Hi Guys,

Thanks for the replies,

I would give you the Execution plan (XML File), give me couple of minutes.

Thanks,

Prabhu

Hi,

Here is where the problem:

update #regions set countryId = (select countryId from tbl_ip2countries where ipFloat between ipFrom and ipTo)

The above update statment will be executed on (roughly 2000 rows as...

Hi Gila,

Yeah, Its true, when I removed two un-wanted indexes over my table, I found the Eager Spool is removed from the Execution plan.

Thanks,

Prabhu