You'll find that logical fragmentation just doesn't matter that much.  Since you lowered the FILL FACTOR as you would for a Random GUID (which the BINARY CHECKSUM resembles in nature),...

This is the code which is creating the problem (bridgid is bigint ,remaks is varchar(250) status smallint) in both the tables mentioned below. INSERT INTO KKR (BridgID,Remarks,Status) SELECT DISTINCT...

Also, if that solution works for...

That's not going to help you...

Awesome.  Now, check the MAX(LEN() of the column so you can right-size it.  It may still need to be a MAX but maybe...

1)it is my stored procedure.

2) I  debuged my sp and it stated running properly. and after that it was also running properly with same params.

but after sometimes it showed...

Trying to get different perspectives! May be I am looking at the things might not be the right. Getting awareness from wise people will definitely make me think...

Glad to see I wasn't the only one to think that.  I subscribed to this thread yesterday to see if the other shoe drops.

And, just to be sure, my initial post didn't cite your response.  It was meant more for the op.  I'll explicitly state that next time.

I know there was no mention of a normal time/attendance table.. that's why I'm mentioning it now. 😉  The overall process should keep track of all time by project/rate and...

Heh... Ya think? 😀

Why is there a...

At first blush, it would appear that the memo field of the file has at least one line in the file where the text of the memo is wider than...

I'm kinda curious why anyone thinks that a separate overtime table is needed at all.

As per app team, this query is executed several times and response times are higher (3-5 secs). We checked for blocking scenarios,

waiting for locks, what other things to be...

It's got to have you wondering, no?  Where the line is to be drawn?  How many doublings do we have remaining?  What really changes because I'm...