Viewing 15 posts - 4,486 through 4,500 (of 22,219 total)
Alvin Ramard (8/25/2016)
Grant Fritchey (8/25/2016)
Lynn Pettis (8/25/2016)
Got to the following from a LinkedIn email. Not sure about a few of the answers.https://intellipaat.com/interview-question/sql-interview-questions/
Holy crap. I can't wait to hear 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
August 25, 2016 at 2:02 pm
Sean Lange (8/25/2016)
Grant Fritchey (8/25/2016)
Lynn Pettis (8/25/2016)
Got to the following from a LinkedIn email. Not sure about a few of the answers.https://intellipaat.com/interview-question/sql-interview-questions/
I posted a comment. I couldn't help it.
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
August 25, 2016 at 2:02 pm
GilaMonster (8/25/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
August 25, 2016 at 1:54 pm
Lynn Pettis (8/25/2016)
Got to the following from a LinkedIn email. Not sure about a few of the answers.https://intellipaat.com/interview-question/sql-interview-questions/
I posted a comment. I couldn't help 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
August 25, 2016 at 1:53 pm
Lynn Pettis (8/25/2016)
Got to the following from a LinkedIn email. Not sure about a few of the answers.https://intellipaat.com/interview-question/sql-interview-questions/
Holy crap. I can't wait to hear that statistics answer in an...
"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
August 25, 2016 at 1:48 pm
Lynn Pettis (8/25/2016)
Anyone hear from spagettidba??The news from Italy keeps getting worse.
And I just got a tweet from him.
"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
August 25, 2016 at 8:16 am
Lynn Pettis (8/25/2016)
Anyone hear from spagettidba??The news from Italy keeps getting worse.
He was tweeting as of two hours ago.
"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
August 25, 2016 at 8:15 am
Eirikur Eiriksson (8/25/2016)
Grant Fritchey (8/25/2016)
Eirikur Eiriksson (8/25/2016)
Taking my girls (7 & 9) to New York this weekend, does anyone have a suggestion on what to do there for their age?😎
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
August 25, 2016 at 7:28 am
Eirikur Eiriksson (8/25/2016)
Taking my girls (7 & 9) to New York this weekend, does anyone have a suggestion on what to do there for their age?😎
The Metropolitan Museum of Art...
"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
August 25, 2016 at 6:07 am
Experiment around with the exevents. I'm pretty sure there's a way to see those, but I could be wrong. I don't have an immediate answer to hand.
"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
August 25, 2016 at 3:59 am
Generally, prepared statements are roughly the same as stored procedures, so they're handled very well indeed. The optimizer can create an execution plan that is reusable across multiple iterations of...
"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
August 25, 2016 at 3:36 am
Yeah, it should. Just use the published trace that's in the documentation.
"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
August 25, 2016 at 3:33 am
TheSQLGuru (8/24/2016)
I don't think it is still "required" but it used to be that upgrading versions mandated full-scan statistics updates on all statistics in every database migrated.
Not at all required,...
"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
August 24, 2016 at 11:54 am
Most of the time, the queries that are suffering because of the new cardinality estimator have other issues that can be addressed (or the architecture is off). Frequently the best...
"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
August 24, 2016 at 10:51 am
Most of SSIS and SSRS management is through Visual Studio, not SSMS. And yeah, you'll probably have to upgrade to the latest database tools for those. SSMS can connect 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
August 24, 2016 at 10:45 am
Viewing 15 posts - 4,486 through 4,500 (of 22,219 total)