Viewing 5 posts - 1 through 5 (of 5 total)
CREATE TABLE tbl_Login_Details(ID INT IDENTITY,Session_SRNO INT)
CREATE NONCLUSTERED INDEX NCX_Login ON tbl_Login_Details(ID)
DECLARE @SESSION_SRNO int
...
May 14, 2015 at 6:36 am
#1797821
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This is the procedure code
/* ...
April 30, 2015 at 2:25 am
#1794593
the sp is using more than 20 tables and too many functions . It is difficult to provide the scripts
April 29, 2015 at 11:31 pm
#1794563
Shall I go ahead and verify the execution plans for performance or?
April 1, 2015 at 4:09 am
#1787933
But in local it is working fine. Not able to c any performance issue.We r not sure, whether it is with sp or
April 1, 2015 at 3:29 am
#1787921