Viewing 15 posts - 16,636 through 16,650 (of 18,926 total)
Just in case you still have a transaction opened :
Rollback distributed tran
June 16, 2005 at 9:56 am
Sorry, I'm not gonna be the first one to implement this.
Could we fast-forward to tomorrow afternoon ?![]()
June 16, 2005 at 9:54 am
Have you tried decimal(18,2) instead of money?
June 16, 2005 at 9:38 am
Actually you're not clear enough.
Can you post the table definition, some sample data along with the expected result you want from this procedure?
June 16, 2005 at 9:36 am
Do you have a distributed transaction opened?
June 16, 2005 at 9:32 am
You have 11 scans in this query... no wonder why it's so slow.
Can you rewrite the query so it uses ansi92 standards?
(Select 1 from a inner join b on a.id...
June 16, 2005 at 9:31 am
You can replace this whole proc with a single query.
What exactly are you trying to do?
June 16, 2005 at 9:26 am
This (convert(varchar(50),ContractDate,101)) will always force a scan to be executed. You'll kill any performance in that query right from the bat.
June 16, 2005 at 9:22 am
set showplan_text on
go
--query goes here
go
set showplan_text oFF
June 16, 2005 at 9:16 am
Be carefull with that technic... You could be losing performance if you are nesting too many queries.
June 16, 2005 at 8:43 am
Viewing 15 posts - 16,636 through 16,650 (of 18,926 total)