Viewing 5 posts - 1 through 5 (of 5 total)
J-F Bergeron (11/11/2009)
lmu92 (11/11/2009)
J-F Bergeron (11/11/2009)
Let's try it with a covering index:Try to create a nonclustered index on CxToken, CxStatus that includes EcxLastTime (included column). ...
@ J-F: Just a...
November 12, 2009 at 12:19 am
J-F Bergeron (11/11/2009)
If it does, or does not do a difference, can you post the execution plan, and tell me how many rows are in the table? Thanks,
OK, will give...
November 11, 2009 at 3:13 pm
Columns
NameData TypeMax Length (Bytes)Allow Nulls
CxIDint4
CxTokenvarchar(20)20
CxStartTimedatetime8
WrkIDvarchar(20)20
UseIDvarchar(20)20
OffCodesmallint2
CxLastTimedatetime8
AppIDvarchar(20)20
ProIDvarchar(5)5
UgrIDvarchar(3)3
PrgIDvarchar(3)3
WkgIDvarchar(3)3
OotTypesmallint2
BpgIDvarchar(3)3
BptIDvarchar(3)3
EcxStatustinyint1
UssSeqNoint4
TzoIDvarchar(3)3
TzoCurrentBiassmallint2
ProPriceGroupvarchar(3)3
VgrIDSalevarchar(3)3
OffAccountingOfgIDvarchar(3)3
Indexes
NameUniqueFill FactorFile GroupColumns
PK___1__12Yes90PRIMARYCxID
ContextStatusKey...
November 11, 2009 at 2:55 pm
lmu92 (11/11/2009)
What is the root cause to have the validation implemented in almost every proc?
It confirms that the 'user' has a valid session within our application. It appears to be...
November 11, 2009 at 2:41 pm
I am fairly sure the SP is as optimised as it can be, however, I've posted it below: -
ALTER PROCEDURE CheckContext
@CxID int,
@CxToken...
November 11, 2009 at 2:28 pm
Viewing 5 posts - 1 through 5 (of 5 total)