Great writeup Arun, this is really helpful, thanks for sharing.

Rohit

Hey Arun,

very nicely written article to address this specific issue and very well summarized.

Keep up the good work buddy.

Cheers have a great day!

Rohit

GilaMonster (9/27/2011)

---

Don't use table variables unless you're using them in a way that doesn't affect the costings (insert into @var and straight select * from @var). Joins, filters, aggregations, etc...

GilaMonster (9/27/2011)

---

Ramji29 (9/27/2011)

---

This makes a bit sense.... Now I'm testing on my test box... and if I rebuild all indexes of the tables involved and update statistics.... Can I expect...

GilaMonster (9/27/2011)

---

The costs are estimates. They are generated at compile time based on estimated row counts and there are many, many ways for them to be wrong (stale statistics, parameter...

Dave Ballantyne (9/27/2011)

---

Hi ,

The query cost relative to batch is based upon the estimated cost, not the actual.

You mention UDF's, estimated cost of UDF's are 0.

That will be...

srinath.vanama (8/16/2011)

---

Hello Folks,

am in similar kind of situation, on one of my Production server there are so many lockings are there it is causing performance problem.

1)I run a query sp_who4...

sue.bandi (3/1/2011)

---

thanks for reply, but one question i have if i change service account of my production server (which i want to take backup), do i need to create that...

sue.bandi (3/1/2011)

---

Hi Kevin,

I dint understand what do u mean by "user Log on'. how can i check that.

Let me tell you am trying to backup my remote server from XP...

this code is used in a udf and that udf is used across all over.. thats y we've used nolock to minimize locking.... apart from this in the link you...

Are you talking about the one table I missed nolock hint or sumthing else??

Yeah seems to be

Post the windows even entries and also check what Andrew pointed out.

Rohit

Can u post table structure, index definition & the select query...

Rohit

Can you check the services and confirm if all the sql services got installed properly??