Viewing 15 posts - 4,741 through 4,755 (of 22,224 total)
ganapathy.arvindan (5/12/2016)
"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
May 12, 2016 at 6:12 am
Try capturing the segmentation elimination with this extended event. It might prove more informative than the execution plan in this situation.
"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
May 12, 2016 at 3:19 am
If you have the time to completely shut down transactions prior to the backup, yes, that sounds like an adequate process and you won't have to worry about the transaction...
"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
May 12, 2016 at 3:14 am
The shortest possible answer to your question is, yes, Availability Groups can substitute for Failover Clusters. However, as Kevin says, we really don't know enough about your situation to make...
"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
May 12, 2016 at 3:08 am
BLOB_EATER (5/12/2016)
Don't...
"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
May 12, 2016 at 3:02 am
I'm with Jacob. The best approach is to use a plan guide. Either use the guide to pass a hint for the query, or, use plan forcing to pick 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
May 11, 2016 at 11:21 am
Eirikur Eiriksson (5/11/2016)
Grant Fritchey (5/11/2016)
My guess is, you may have hit some bad parameter sniffing on the query that was running fast...
"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
May 11, 2016 at 9:19 am
Without seeing the execution plans, I'd just be guessing.
My guess is, you may have hit some bad parameter sniffing on the query that was running fast previous to the addition...
"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
May 11, 2016 at 8:23 am
Instead of moving all the data into the temporary table, then running the processing against it, I'd suggest you put a WHERE clause on the Bulk copy so you don't...
"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
May 11, 2016 at 8:21 am
check the wait statistics for those queries while they are running to understand where the slowdown is occurring. It's possible it's the memory, cpu or I/O of your local system....
"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
May 11, 2016 at 8:15 am
Just be clear, Redgate isn't a source control management system. It's a way of integrating with TFS or Git or Mercurial or Subversion. Pick the source control system that your...
"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
May 11, 2016 at 3:09 am
You should take another look at the syntax for the UPDATE statement.
As Lynn says, you're missing quite a bit there. Your statement should look something more like:
UPDATE dbo.MyTable
SET Column1...
"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
May 11, 2016 at 3:08 am
Mark Cowne (5/9/2016)
Really enjoyable few days, lots of excellent presentations, Itzik Ben-Gans was simply brilliant. Also got a chance to briefly meet Grant and Steve.
And it was a pleasure.
Loved Bits....
"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
May 10, 2016 at 12:07 pm
It was great to see Threadizens last week at SQL Bits. Awesome event.
And I had something I was supposed to say about Gianluca... just can't remember what it was... (keep...
"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
May 10, 2016 at 4:17 am
Brandie Tarvin (5/9/2016)
Ed Wagner (5/9/2016)
Phil Parkin (5/9/2016)
Eirikur Eiriksson (5/9/2016)
Who needs a desk when one can bang ones head against this?😎
Occam's razor clearly does not apply in this case. Instead, perhaps,...
"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
May 10, 2016 at 4:14 am
Viewing 15 posts - 4,741 through 4,755 (of 22,224 total)