Viewing 15 posts - 5,461 through 5,475 (of 22,227 total)
BrainDonor (10/6/2015)
BL0B_EATER (10/6/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 11:21 am
Just make sure this is a one-time shrink. If you get in a situation where you're shrinking over and over, that leads to issues down the road.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 8:26 am
GilaMonster (10/6/2015)
Because SQL's taken either a page lock or a table lock, probably due to inadequate indexing, maybe due to the way the query was written
Or both.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 8:25 am
Markus (10/6/2015)
The NOLOCK hint is a left over from when this was...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 7:34 am
JaybeeSQL (10/6/2015)
On an aside, anyone here use SQL Backup Pro? Any big advantages over native MSSQL processes?
Oh, and I forgot, a wizard for setting up backup testing (aka, a...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 7:13 am
JaybeeSQL (10/6/2015)
On an aside, anyone here use SQL Backup Pro? Any big advantages over native MSSQL processes?
I work for the company so...
Absolutely!
The biggest advantage is in multi-server management. You...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 7:12 am
Michael L John (10/6/2015)
Ed Wagner (10/6/2015)
BWFC (10/6/2015)
Sadly, I see that exact situation all the time.
I can't get my head around that kind of attitude, particularly when there'e so much...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 7:08 am
GilaMonster (10/6/2015)
Grant Fritchey (10/6/2015)
Unless they're starting a transaction and then walking away with it uncommitted.
Seen that happen before. Brought am entire application to a complete standstill on all users' machines.
If...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 7:01 am
jellybean (10/6/2015)
update someTable
set='newValue'
where someField='oldValue'
As I say -...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 6:35 am
Unless they're starting a transaction and then walking away with it uncommitted. That would lead to this issue, possibly. As Gail says, we don't know what objects are being locked...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 6:30 am
I'd suggest taking a look at the Minion tools, in your case Minion Backup[/url].
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 6:28 am
I might help some, but probably not much, especially considering the amount of memory you have on the system.
Locking and blocking are primarily an issue related to code and data...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 6, 2015 at 6:26 am
You should be able to take another log backup and, assuming it succeeds, everything should be fine. You can check it by using RESTORE HEADERONLY to look at the Log...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 5, 2015 at 4:38 pm
Eirikur Eiriksson (10/5/2015)
Grant Fritchey (10/5/2015)
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 5, 2015 at 4:12 pm
You can give the files any extension name, but it's the path and security to that path that are going to make the difference. Before you run the command to...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 5, 2015 at 11:43 am
Viewing 15 posts - 5,461 through 5,475 (of 22,227 total)