Viewing 15 posts - 38,686 through 38,700 (of 49,552 total)
mathieu_cupryk (6/3/2009)
You can you show me what you mean.
Move the COMMIT TRANSACTION so that it's just before the END TRY. I just noticed there's already a rollback in the catch,...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 3:00 pm
Maybe the Sage programming guide will help you. This is the first I've ever heard of the language.
http://www.google.com/search?q=sage+programming+guide
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 2:21 pm
As the error says, you're asking SQL to commit a transaction that's not commitable (because the catch block was invoked). Move the commit tran into the TRY block and add...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 2:15 pm
Robert klimes (6/3/2009)
... the query is doing a clustered index scan or worse a table scan ...
A clustered index scan is essentially a table scan, since the clustered index has...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 2:12 pm
dsbolanos (6/3/2009)
Can anyone tell me what could be wrong? or any clue?
If you're going to query a 45 million row table with no useful index, you should expect it to...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 2:10 pm
Disk queue's almost impossible to interpret meaningfully when there's a SAN. Too many variables involved.
Check Avg sec/read, Avg sec/write and % disk idle time instead.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 2:01 pm
The values returned from perform are seconds/read. So to get to milliseconds/read, multiply the value by 1000.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 1:46 pm
What rights your account has on the local machine/domain is irrelevance. What the SQL Server Service account is may have some effect on this. Check what rights the SQL service...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 1:44 pm
mathieu_cupryk (6/3/2009)
{"Conversion failed when converting the nvarchar value 'ticketID 0' to data type int."}
In the following statement
SET @resultMessage = 'ticketID ' + CAST(@ticketID AS NVARCHAR(200))
+ ERROR_NUMBER() + '. ' +...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 1:42 pm
Try updating statistics on that table when the problem happens
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 1:40 pm
Jack Corbett (6/3/2009)
I'm going to have to agree with GSquared on this one. This definitely does not belong in a trigger
In fact, it belongs in the client-side validation before the...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 9:45 am
GSquared (6/3/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 9:41 am
SQL runs on a server. If the trigger were to pop up a message box, where do you think it would pop up?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 9:24 am
Jules Bonnot (6/3/2009)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 9:20 am
Jules Bonnot (6/3/2009)
Hi would you mind expanding your post a little.What are the disadvantages of having heaps.
Forwarding pointers and the resulting increase in IO. Only an issue when there...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 3, 2009 at 8:07 am
Viewing 15 posts - 38,686 through 38,700 (of 49,552 total)