Viewing 15 posts - 7,606 through 7,620 (of 49,571 total)
Eirikur Eiriksson (10/4/2014)
Is it just me or does this smell like a spam? A quick search returned few similar postings referencing the same vendor on other sites.😎
It's the same kind...
October 6, 2014 at 6:02 am
I mean your checks to see if it was safe to delete the log file were inadequate...
October 6, 2014 at 5:58 am
Maybe it wasn't actually repaired, just deallocated by something like an index rebuild.
October 4, 2014 at 3:59 am
SQL logs an entry in suspect pages when it finds a corrupt page. In your case, that happened on the 11th of last month and SQL only found an error...
October 3, 2014 at 3:16 pm
Great, so post them please. Pictures of SSMS's graphical rendition of the deadlock graph files is useless as it's only part of the information. Hence why I asked for the...
October 3, 2014 at 3:15 pm
No, it cannot, as the error message says.
October 3, 2014 at 11:15 am
If you need to sum the entire Transactions table 300 times a second (with no filtering or grouping), I'd say you need to either reconsider your design or your requirements....
October 3, 2014 at 10:58 am
That's very likely going to be the source of those waits then. SQL's probably calling out to the OS to do the encryption and decryption of the messages.
October 3, 2014 at 9:13 am
aykut canturk (10/3/2014)
my logic says less lock is better.
It's no where near that simple.
Is using the hint going to damage the database? Of course not.
That doesn't mean you...
October 3, 2014 at 9:11 am
Running service broker?
Using any encryption anywhere?
October 3, 2014 at 8:09 am
But in that case, what's the point of the hint?
You said that data is not getting updated, so why would you need a hint that lets you read through exclusive...
October 3, 2014 at 7:34 am
kevaburg (10/3/2014)
The table sys.dm_exec_sql_text only stores currently executing SQL and once the execution is completed will be removed.
Currently cached, not currently executing, but otherwise, yeah. An insert ... values is...
October 3, 2014 at 7:16 am
Please note: 4 year old thread. Please post new questions in a new thread. Thank you.
October 3, 2014 at 7:10 am
aykut canturk (10/3/2014)
but my my question is "is there anything wrong to use WITH (NOLOCK) for reading non-changing fields"
Yes.
as I don't need exact results and I'm okay with dirty...
October 3, 2014 at 6:50 am
A select alone cannot deadlock. There's likely more to that transaction and there's definitely another process involved.
If you can get hold of the deadlock graph, it'll be possible to fix...
October 3, 2014 at 5:37 am
Viewing 15 posts - 7,606 through 7,620 (of 49,571 total)