Viewing 4 posts - 1 through 4 (of 4 total)
here is the execution plan...
If we get this proc to run 20 or 10 ms, it will be a success. The whole process consists mainly of these 50 runs of...
October 13, 2009 at 2:02 pm
What's the "DDL" for the table?
Index definition follows:
CX_tSCLedgerAccount_fAccount clustered located on PRIMARYfCompanyID
IX_tSCLedgerAccount_fAccountfCompanyIDfCapital_Ver_1.28.0022nonclustered located on PRIMARYfAccount, fCompanyID, fCapital
IX_tSCLedgerAccount_fCapital__Ver1.28.0022nonclustered located on PRIMARYfCapital
IX_tSCLedgerAccount_fCompanyID__Ver1.28.0022nonclustered located on PRIMARYfCompanyID
IX_tSCLedgerAccount_fCompanyID_Incl_all_Ver1.28.0022nonclustered located on PRIMARYfCompanyID
IX_tSCLedgerAccount_fCompanyIDfPropertyIDfAccount__Ver1.28.0022nonclustered located...
October 13, 2009 at 1:34 pm
J-F, thak you.
That's a good question...It's returning 2,625 rows - so a minimal set from the whole total. It's called probably like 50 times or so. The application was designed...
October 13, 2009 at 1:29 pm
Sorry...as soon as I posted this thing...I figured out what the problem was. It had nothing to do with the assignment I was looking at. It had to do with...
January 8, 2009 at 9:44 am
Viewing 4 posts - 1 through 4 (of 4 total)