Viewing 15 posts - 4,036 through 4,050 (of 49,571 total)
The deadlock is not coming from a select.
What you have, at the time the deadlock happens, is one session that holds an X lock already on one row (and will...
December 10, 2015 at 1:48 pm
Um...
SQL-DBA-01 (12/10/2015)
will run in every 30 secs to take more frequent tlog bkps until the job (full bkp) is completed.
The log won't truncate until the full backup finishes, that's the...
December 10, 2015 at 1:21 pm
That's not a lock conversion, and SQL will never convert an X lock to a U. Lock conversions are to more restrictive lock modes. U is less restrictive than X.
From...
December 10, 2015 at 12:44 pm
Ok, and?
The log is full, you've seen that. It's full because a transaction is open and hence the space in the log can't be reused. The procedure with the transaction...
December 10, 2015 at 12:41 pm
Ok, so you're filling the log with a transaction. What's the question?
December 10, 2015 at 11:49 am
Frank Dijk (12/10/2015)
For your info: It is MySQL (if that matters).
Yes it does. This is a Microsoft SQL Server forum. We know MS SQL, not MySQL, so solutions posted here...
December 10, 2015 at 11:48 am
No.
The log won't truncate until the full backup finishes, that's the only difference to running the log backup any other time.
December 10, 2015 at 11:46 am
Fandy08 (12/8/2015)
So, definitively, the reason must have been bad plans after reorg of indexes
No. Not bad plans. Plans which run more data through the UDFs than previously, resulting in the...
December 10, 2015 at 4:10 am
No, we're not. We don't have the rigour, the formality, the adherence to standards that characterises engineering disciplines. The scientific method is not 'try stuff at random until something works',...
December 10, 2015 at 3:53 am
It'll take a while. Do it in 5GB or so chunks.
December 10, 2015 at 3:32 am
IF is a control flow statement. It's used outside of queries to determine whether a statement should run or not. It can't be used inside a query.
You probably want something...
December 10, 2015 at 3:30 am
And speaking of the boss, I just sent him an email with no text, just two screenshots. Flight prices Johannesburg to London return, train prices London to Liverpool return. Let's...
December 9, 2015 at 2:48 pm
jasona.work (12/9/2015)
that also happens to be a day I'm sure Gail is waiting for...Star Wars: The Force Awakens release day!
It's releasing here on the 16th, which is a public holiday....
December 9, 2015 at 2:23 pm
rodjkidd (12/9/2015)
Wed May 4th to Sat May 7th
Liverpool Exhibition Centre
Now what do to about the ticket I have for Yes...
December 9, 2015 at 9:42 am
Viewing 15 posts - 4,036 through 4,050 (of 49,571 total)