Merger Join -- if the both left and right tables are sorted then merge join will take place.

Nested loop-- If the left side table having less number of rows and...

Thanks Gail Shaw.

Can you share me some example or any links which describes what you have said.

Its one of best practice in my comapny to not...

Thank you very much both of you :). Just i wanted to know internally how it detrmines dead lock is happened and how it checks each and every time,

what...

Okay

Thank you very much

Ravi.

Thank you very much all for your valuble suggestions and solutions 🙂 .

Regards,

Ravi.

Thank you . But i have read it already , i need indetail exactly in index page and data page how many jumps it requires and more in detail...

Thank you very much for both of you .

Thanks,

Ravi

Microsoft SQL Server 2005 - 9.00.1399.06

example of code

declare @date datetime

set @date=getdate()

INSERT INTO CourseFeedback (Courseid,UserID,Feedbackxml,CreatedDate)

VALUES (@CourseId,@UserID,@Feedbackxml,@date)

example of code

INSERT INTO CourseFeedback (Courseid,UserID,Feedbackxml,CreatedDate)

VALUES (@CourseId,@UserID,@Feedbackxml,GETDATE())

No its a DateTime field only .

Okay .

Thank you very much .

Thank you very much

Actually my sql statment like this

SELECT DISTINCT UPP.ProductID,dbo.fnGetProductTestStatus(UPP.ProductID,@UserID) AS EndDate ,

FROM #UserProductProgression UPP

when i say like that...

Fine thanks a lot , Please can you suggest me any sites or blogs to know how to use ssis for archiving ?

Thanks with Regards,

Ravindranath.S