Viewing 15 posts - 6,871 through 6,885 (of 22,226 total)
Steve Jones - SSC Editor (1/21/2015)
What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for the Friday night party.
Need to get...
"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
January 22, 2015 at 7:55 am
Jeff Moden (1/21/2015)
Sioban Krzywicki (1/21/2015)
I hope everyone here is ok with it too...
To be honest, I don't care if someone's eyes are on stems and they leave snail tracks. ...
"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
January 21, 2015 at 2:20 pm
free_mascot (1/20/2015)
search engine work differently in different version to improve the performance. However while doing upgraded one should keep the db in the original compatibility mode unless...
"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
January 20, 2015 at 6:32 am
Doing the rebuilds online can reduce contention, but it will increase the amount of time it takes. It's a tradeoff.
"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
January 20, 2015 at 6:30 am
The execution plan is your bestest buddy in situations like this.
Joining to views is a common code smell in T-SQL. The language just doesn't lend itself to code reuse. While...
"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
January 19, 2015 at 1:16 pm
I am clearly biased, but check out the books below in my signature.
"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
January 19, 2015 at 1:12 pm
It could be any number of things. First thought is the changes to the cardinality estimator. See how many rows the execution plans think it's going to get from 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
January 19, 2015 at 1:09 pm
Move your mouse to the lower left corner of the window and you'll see an icon. Or, go to the lower or upper right corners and you'll get a charms...
"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
January 19, 2015 at 6:05 am
to really understand which of the queries are giving you the most pain, I strongly suggest you run the trace file through the RML Utilities (you'll have to recapture one...
"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
January 19, 2015 at 5:58 am
Also remember that these processes are subject to blocking and resource contention. It could just be that there were more shared locks or something causing waits on the rebuild process...
"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
January 19, 2015 at 5:54 am
Test, test, test, test, test.
I agree that keeping it simple and using ALTER TABLE is the right answer most of the time. I also agree that you may see...
"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
January 19, 2015 at 5:52 am
Eirikur Eiriksson (1/19/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop,...
"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
January 19, 2015 at 5:48 am
Eirikur Eiriksson (1/19/2015)
Grant Fritchey (1/18/2015)
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop,...
"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
January 19, 2015 at 5:45 am
WayneS (1/18/2015)
How many folks have a home lab set up with servers?
How many folks just use virtual machines on a computer (be it laptop, etc)?
Other?
If you feel 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
January 18, 2015 at 12:58 pm
Very few choices there. You'll have to clean the data. Decide which dates are supposed to be correct and modify them. No other way around 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
January 18, 2015 at 7:08 am
Viewing 15 posts - 6,871 through 6,885 (of 22,226 total)