No.

I am looking from same server only. But need to test result set for code changes in the Sproc.

Thanks for the replies.

I heard from some one instead of reading the table 3 times it is better to read one time. So I thought of using in single query

Hi,

I am still new to the SQL Server. So I want to know all your experiences.

If you want send a report that the SP is taking this time and I...

Sorry my mistake.

I find it from this link

http://technet.microsoft.com/en-us/library/bb522526%28v=sql.105%29.aspx

Thanks

Thanks for you quick reply.

I am using windows 8. So from the task manager I can check the services. From that service tab I am able to see that SQL...

Ok.

If we forget about mine and come to the general situation. In usually what could be the possible reasons causes of high execution time if we execute SP immediately second...

I need help but unfortunately I am unable to provide the execution plan and queries.

I use with recompile option and send that execution time to them

Ok Lynn.

I have a table in db like this to log the each application execution time

CREATE TABLE [dbo].[AppTimeLog](

[TimingLogID] [int] IDENTITY(1,1) NOT NULL,

[ApplicationName] [nvarchar](150) NOT NULL,

[Phase] [nvarchar](150) NOT NULL,

[TransactionName] [nvarchar](150) NOT...

Yes Gail.

Actually I am getting some syntax error while executing that, so in the mean while I posted here to find any alternative.

I heard that for large table we can't use exist or not-exit will be problem.

First time it took 2000msec and later it took 5000msec.

Hi thanks for your reply.

Code is confidential. So I am unable to provide the execution plan but I can explain what is the problem.

I have a Stored procedure and I...

Thanks Jeff.

Actually here I think I don't need to consider the parameter sniffing. Because both times I use only default parameters but still the execution times are different.

I am wondering that usually when we execute the stored procedure several times. The execution time should be less but in my case the execution time is taking longer. Not...