Viewing 15 posts - 9,511 through 9,525 (of 22,219 total)
Talib123 (9/25/2013)
Grant Fritchey (9/25/2013)
"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
September 25, 2013 at 7:53 am
Bhuvnesh (9/25/2013)
Grant Fritchey (9/25/2013)
Log backups are different.But how does the LSN get matched ? i mean their sequence because that will be required to ordered restore
Take 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
September 25, 2013 at 7:31 am
Full backups and the log backups are disconnected. You can go back to BackupA and then run all the transaction logs. Full backups and log backups are not linked like...
"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
September 25, 2013 at 6:59 am
The backup process is a page by page copy of the database. So the restore process is the same. For any object to simply be missing means that it 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
September 25, 2013 at 4:45 am
sunny.tjk (9/24/2013)
Grant Fritchey (9/14/2013)
"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
September 24, 2013 at 4:45 pm
Without looking at execution plans, nope. I can't tell you what's happening. Adding the TOP doesn't "actualize the table in tempdb" whatever the heck that means. It does give the...
"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
September 24, 2013 at 8:43 am
Check sys.dm_exec_requests while the query is running to understand what is causing it to wait. That's the best method. Anything else is just guessing.
"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
September 24, 2013 at 8:37 am
Just piling on, but, no execution plan, we're just making crazy guesses that will likely have absolutely no bearing on reality.
Oh, and no_lock... that is just such a dangerous crutch...
"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
September 24, 2013 at 7:15 am
I primarily only use table variables where I need to avoid recompiles for some reason. Otherwise, the cost incurred by the lack of statistics is almost always not worth it.
"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
September 24, 2013 at 7:09 am
In order to rearrange the index, SQL Server must put locks on that index. While locked, other users can't get access to it. The way around this is, if you're...
"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
September 24, 2013 at 7:05 am
Jeff Moden (9/23/2013)
Grant Fritchey (9/23/2013)
"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
September 23, 2013 at 8:20 am
Rolled out an explosive. It could be a lady finger or a nuclear bomb. Curious how it's going to go off. Stand by for a fizzle or a big bang.
"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
September 23, 2013 at 7:41 am
hisakimatama (9/20/2013)
"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
September 20, 2013 at 10:43 am
steve.fortner 92896 (9/19/2013)
"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
September 19, 2013 at 3:51 pm
steve.fortner 92896 (9/19/2013)
"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
September 19, 2013 at 3:36 pm
Viewing 15 posts - 9,511 through 9,525 (of 22,219 total)