Viewing 15 posts - 38,701 through 38,715 (of 49,571 total)
ldfs(log files) aren't in filegroups. Only data files (mdf, ndf) can be part of filegroups.
June 4, 2009 at 12:40 am
TRACEY (6/3/2009)
So take my results * 1000....why the 1000 sorry being dumb over here.
Because 1 second = 1000 milliseconds
Hmmmm the 345 seconds is a big red alarm if < 12...
June 4, 2009 at 12:35 am
Statistics are updated (with fullscan) for an index when that index is rebuilt. Not when it is reorganised.
Reference: Books Online
http://technet.microsoft.com/en-us/library/ms190397.aspx
Operations such as rebuilding, defragmenting, or reorganizing an index do not...
June 3, 2009 at 3:57 pm
That looks OK. Does it run?
June 3, 2009 at 3:17 pm
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,...
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.
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...
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...
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...
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.
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.
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...
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() + '. ' +...
June 3, 2009 at 1:42 pm
Try updating statistics on that table when the problem happens
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...
June 3, 2009 at 9:45 am
Viewing 15 posts - 38,701 through 38,715 (of 49,571 total)