Thanks Everyone.

Please let me know,

How the table spool effect the performance? In what situation we can get table spool in execution plan and how can we avoid that?

Hey,

I can't post the query here but I can change the names and I will post that.

Hi Lowell,

Thanks for your reply. I am looking for the different one. I do have that where clauses but I am trying to avoid the left outer joins. I didn't...

Thanks Jeff,

I am thinking that insert into bulk logged operation.

How the recovery model effect the performance here? In simple recovery log will not grow. We can't take any log...

Hi SQL RNNR,

Your opinion is that there will nothing performance difference. Either way of creation of temp table is same.

Yes. They are executing different Stored Procedures

Ok. Thanks

They are saying in proc

Thanks for the replies.

Our environment is something product selling. We do have App Fabric cache thing. Whenever customer come and try to buy the products we will some id for...

Thanks for all replies.

In case with the table structure they didn't define the PK, then surely we can give suggestion to modify that table by creating the PK. We don't...

Hi,

Is there any website like this to discuss about the .net or iis related queries.

Hi,

Instead of application identity, I choose local system identity. Let me know, Is it works or do I need to change?

Thanks

Hi Adam,

Thank you. What kind of service account do you want to me create. This is my first time working with iis. How to create that service account for app...

Hi,

Actually what I understand is I have to run those web services under my user name in iis. I created the app pool with my user name but it is...

Hi Adam,

Some one told me we need to create application pool for each service that we want to localize. Is that right? What is the application pool does? Please let...