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 will probably be moderated out since all the other comments appears to be glowing reviews and yours isn't visible.
Yeah, whatever. I'm never going back there again if I can help it, so...
"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
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 statistics answer in an interview. I might not stop laughing, ever.
2.When is the UPDATE_STATISTICS command used?
My answer? Whenever you think it's time to update statistics. 😀
You do know that's a better answer, right?
"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:05 pm
Grant Fritchey (8/25/2016)
GilaMonster (8/25/2016)
If you were to attend a keynote presentation on "New features of SQL 2016", would you prefer brief demos of each new feature? Just discussion, along with code/screenshots on slides, and use the time to get into detail on each new feature?Keynote's only 1 hour, so not time to do both. I'm leaning towards the latter, similar to the SQLBits keynote from last year, or the day 2/3 keynotes from PASS the last few years.
Nah, run through some stuff and drill down, a little, on one really cool one that you can whip up passion about. I recommend Query Store.
I'll probably demo Query Store with live query stats and PowerBI (will bug colleagues to help with the PowerBI bit)
Temporal Tables
Stretch DB
JSON Support (the seminar is on web and mobile development, hence this will probably be interesting)
Dynamic Data Masking
Always Encrypted
Row-level Security
R Services
Power BI
Query Store
Live Query Stats
Am I forgetting anything?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2016 at 2:05 pm
Grant Fritchey (8/25/2016)
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 statistics answer in an interview. I might not stop laughing, ever.
2.When is the UPDATE_STATISTICS command used?
My answer? Whenever you think it's time to update statistics. 😀
You do know that's a better answer, right?
Yes! 🙂
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2016 at 2:07 pm
Grant Fritchey (8/25/2016)
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 will probably be moderated out since all the other comments appears to be glowing reviews and yours isn't visible.
Yeah, whatever. I'm never going back there again if I can help it, so...
But I read it on the internet so it must be true!!!
-Ghandi
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
August 25, 2016 at 2:08 pm
GilaMonster (8/25/2016)
Grant Fritchey (8/25/2016)
GilaMonster (8/25/2016)
If you were to attend a keynote presentation on "New features of SQL 2016", would you prefer brief demos of each new feature? Just discussion, along with code/screenshots on slides, and use the time to get into detail on each new feature?Keynote's only 1 hour, so not time to do both. I'm leaning towards the latter, similar to the SQLBits keynote from last year, or the day 2/3 keynotes from PASS the last few years.
Nah, run through some stuff and drill down, a little, on one really cool one that you can whip up passion about. I recommend Query Store.
I'll probably demo Query Store with live query stats and PowerBI (will bug colleagues to help with the PowerBI bit)
Temporal Tables
Stretch DB
JSON Support (the seminar is on web and mobile development, hence this will probably be interesting)
Dynamic Data Masking
Always Encrypted
Row-level Security
R Services
Power BI
Query Store
Live Query Stats
Am I forgetting anything?
All in one hour? Hope you can talk fast 🙂
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
August 25, 2016 at 2:18 pm
Sean Lange (8/25/2016)
Grant Fritchey (8/25/2016)
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 will probably be moderated out since all the other comments appears to be glowing reviews and yours isn't visible.
Yeah, whatever. I'm never going back there again if I can help it, so...
But I read it on the internet so it must be true!!!
-Ghandi
Looking at the names of people that posted all those good comments .... Yep, that's what I was expecting. Hate to say it, but ... Oh well. Shall we say the blind leading the blind?
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2016 at 2:18 pm
Sean Lange (8/25/2016)
Grant Fritchey (8/25/2016)
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 will probably be moderated out since all the other comments appears to be glowing reviews and yours isn't visible.
Yeah, whatever. I'm never going back there again if I can help it, so...
But I read it on the internet so it must be true!!!
-Ghandi
"Don't Believe Everything You Read On The Internet"
-Abraham Lincoln
August 25, 2016 at 2:22 pm
Luis Cazares (8/25/2016)
Sean Lange (8/25/2016)
Grant Fritchey (8/25/2016)
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 will probably be moderated out since all the other comments appears to be glowing reviews and yours isn't visible.
Yeah, whatever. I'm never going back there again if I can help it, so...
But I read it on the internet so it must be true!!!
-Ghandi
"Don't Believe Everything You Read On The Internet"
-Abraham Lincoln
Should I believe Lincoln? hmmmmm :unsure:
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 25, 2016 at 2:24 pm
Phil Parkin (8/25/2016)
All in one hour? Hope you can talk fast 🙂
That's why I don't want to demo every feature. I can cover that in an hour, but if I have to demo everything, then I'll be able to cover maybe 1/3 of that list.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 25, 2016 at 2:25 pm
They must be proud of their site. It helps unqualified people get jobs they can't handle.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2016 at 2:29 pm
The Dixie Flatline (8/25/2016)
They must be proud of their site. It helps unqualified people get jobs they can't handle.
Can you believe they also charge for their courses?
I can picture their motto: "Preparing the unqualified developers of tomorrow, today."
August 25, 2016 at 2:32 pm
GilaMonster (8/25/2016)
A few of them? I don't think a single one is correct.
I didn't make it through all of them so I couldn't speak to the ones I didn't read.
August 25, 2016 at 2:34 pm
Hmmmm... maybe it's a trap site that employers sponsor to spoon-feed wrong answers to job applicants who don't know any better! 😀
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills
August 25, 2016 at 2:38 pm
Actually, question 17 is correct. The default port for SQL Server is 1433.
Viewing 15 posts - 55,516 through 55,530 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply