Viewing 15 posts - 4,741 through 4,755 (of 22,219 total)
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
Chad Crawford (5/2/2016)
TomThomson (4/30/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 3, 2016 at 4:18 am
Jeff Moden (4/30/2016)
Grant Fritchey (4/28/2016)
I want to export large amounts of data. However, I don't want to use SSIS. I'm going to use SQLCMD.EXE. I need to be able...
"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 1, 2016 at 12:28 pm
ajdba33 (4/30/2016)
Also, has anybody used SQ Sentry PowerSuite tool ? I would like to compare few...
"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 1, 2016 at 12:20 pm
harikumar.mindi (4/30/2016)
EXEC sp_MSForEachTable 'UPDATE STATISTICS ? WITH FULLSCAN;'However i will rebuild / reorganize indexes and test it again and will update here.
Just so you know, rebuilding/reorganizing indexes will not...
"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 1, 2016 at 12:18 pm
You're kind of all over the map here, but I'll be happy to make some suggestions.
First off, get the SQL Toolbelt from Redgate[/url]. It has a number of tools that...
"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
April 30, 2016 at 7:29 am
Viewing 15 posts - 4,741 through 4,755 (of 22,219 total)