Hi,

I checked out the pinned tables in BOL. There was a warning saying large tables should not be pinned. I know 50,000 users table is not large, but it is...

I looked at the execution plan. For login sproc, the query cost for IF statement is 24.41%, for UPDATE it is 51.21%, for SELECT it is 24.38%. But all this...

Login sproc

------------------------------

CREATE PROCEDURE [dbo].[proc_userverifylogin]

@email varchar(100), @pass varchar(50)

AS

IF EXISTS (SELECT * FROM users WHERE email = @email AND pass = @pass)

BEGIN

UPDATE users SET lastlogin = GETDATE() WHERE...

Luckily I got the timeout error when I tried to login to our wbesite yesterday. This is what happened. I entered the email and password and tried to login, it...

Arghhh...Can any one tell me what am I doing wrong. Shouldn't both the queries return the same result?

SELECT userid, name, email

FROM users usr

WHERE NOT EXISTS (SELECT * FROM usersubscriptions usub...

Hi,

I created a counter log and allowed it to run over the weekend. But no error occured in that time period.

May be its due to some memory intensive operation...

Thanks for the tip. I will try it out.

Here is the stored procedure.

CREATE PROCEDURE [dbo].[proc_searchusers]

@userstatus CHAR(1),-- active or inactive

@usertype CHAR(1), -- free or pay1 or pay2

@emailflagged CHAR(1),-- yes or no

@landmailflagged CHAR(1),-- yes or no

@name VARCHAR(100),-- replaced *...

Hi,

I know how to use a profiler. The error is not occurring everytime. I get 3-5 timeout errors in a span of 2 mins. Then I don't see any error...

Hi,

I posted the original message a month back. I ignored the error as it went away after some time. Now I am getting this same timeout error again.

And 90%...

Thanks much.

Instead of a table with all possible dates, can I create a UDF that takes startdate and enddate, and return all the in-between dates and insert this into a table...

I checked it. Its not the same. Sorry.

The table I am working on inside the sproc and the table I am trying to insert into have the same definition. But...

I checked it. Its the same.

This is the error detail I have.

--------------------

Error Message:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Stack Trace:

...