Viewing 15 posts - 36,571 through 36,585 (of 49,562 total)
This article goes over how to save and attach execution plans. There's not enough information in just a screenshot. Most of the important details are in the properties of the...
September 4, 2009 at 8:36 am
TheSQLGuru (9/4/2009)
September 4, 2009 at 8:28 am
I think part of the question is why an explicit transaction for a single update?
You could remove both the ROLLBACK and the RETURN and not change the behaviour, nothing'll be...
September 4, 2009 at 8:27 am
Form that the select is blocked, waiting for a lock. Can't see what table teh lock is requested on (query sys.partitions and sys.tables for the partition_id 72057594308001792 to get the...
September 4, 2009 at 8:25 am
Chirag (9/4/2009)
September 4, 2009 at 7:40 am
nitin jain (9/4/2009)
September 4, 2009 at 6:56 am
Ok, not good.
Firstly, what did the SQL error log say about why MSDB was marked suspect? There would have been a reason in there.
If you remove the traceflag, does the...
September 4, 2009 at 6:55 am
You can use Row_Number.
If you want more specific help, please post table definitions, sample data and desired output. Read this to see the best way to post this to...
September 4, 2009 at 4:40 am
If you want us to help optimise, please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
PageIOLatch is typically a sign of IO contention. The IO subsystem cannot...
September 4, 2009 at 1:11 am
Jeff Moden (9/3/2009)
He was probably using sp_Space used or some code that looks at sysIndexes and DBCC UPDATEUSAGE fixes some sins that occur there.
The code he initially posted (before editing...
September 4, 2009 at 1:08 am
ben.mcintyre (9/3/2009)
Hmmm ....The silence in this thread is almost deafening.
I was going to dig into this over the weekend. Been rather busy prepping and delivering a presentation and then catching...
September 4, 2009 at 1:02 am
Grant Fritchey (9/3/2009)Is BOL translated to languages other than English? That's the kindest explanation I can come up with.
It is, but not having a clue what his native language is...
September 3, 2009 at 4:37 pm
jmiaebrown (9/3/2009)
Is there a way to evaluate the number of rows from the update and then explicitly go to the catch block?
It's easy to evaluate the number of rows...
September 3, 2009 at 4:34 pm
CirquedeSQLeil (9/3/2009)
does that mean he has learned how to research the issue and troubleshoot?
Based on this I have to say 'No'
September 3, 2009 at 4:08 pm
It won't go to the error handler if you pass a userID that affects no rows. Updating 0 rows is not an error. Something like a constraint violation, data conversion...
September 3, 2009 at 4:04 pm
Viewing 15 posts - 36,571 through 36,585 (of 49,562 total)