LutzM (2/9/2012)

---

You could try to run the two statements in reverse order.

I'm confident "all of a sudden" the query running "fast" in the beginning will be the "slow" one.

What is...

Sure, Gail Shaw...

I will test with another application for the results as I can't do much on these statements because LID is PK so its unique,

Location is also unique per...

Sure, for the 1st stament SQL Server parse and compile time:

CPU time = 0 ms, elapsed time =...

Yes, these are the two commands I have been used for test before..

I just tried once again No luck....

But this time

--1)

SET STATISTICS IO ON

SET STATISTICS TIME ON

Update ActrProfile

set LCount =...

It's Just one row all the times.

If table Actors is large and ScreenID is not...

No, not at all. The query optimiser generates the best plan it can based on the query, the indexes, the data distribution, etc. The order that you specify the conditions...

Won't make a difference. Order of predicates in a where clause is irrelevant.

Thank you Gail Shaw,

And If it doesnt really matter the order in where clause, I Would just use...

HI Ninja's_RGR'us,

I am not sure usage of cte,as I dont work with before..

Could you please walk me through, If possible.

I will really appreciate.

Hi Ninja's_RGR'us, Thanks for your quick reply..

It works, But problem is here. when I was applying this

Create procedure studentRanks(@studentid int)

as

select st.studentName,

st.StudentAddress,

(SELECT marks,ranks FROM (select studentid,marks,RANK()over(partition by sub_id order by...

Can you please describe that If you can?

Thanks

@WC

I appreciate your suggetion, But I have identity column which takes care of the uniqueness for the username...

I mean all the queries I wrote def. call the identity column.

Ofcourse...

@Welsh Corgi,

You are going to create a single column for User Name?

Yes, username is single column

How about a First Name, Last Name and a User Name?

It (the username) should just...

@ GSquared,

Yes finally I have decided to do normalization, as we dont have any other way...

Thank you very much to all of you for the response.

Yes, jerry-621596.

It seems,I have only that option in my hand..

And the joins I was talking which operates the DML 's to maintain subtables. I know, those very simple..But I was...

Hi Evil Kraig F,

I am sorry If I made you to understand differently..

I am saying I would do normalization as well as joins..It is the only option which I...