August 25, 2016 at 12:53 pm
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 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.
Me personally I would prefer brief demos on each feature so then I would be comfortable to dive in on my own time.
August 25, 2016 at 12:57 pm
BLOB_EATER (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/
What on earth is number 19 about? Clr.... VAS?
Neither, I think. Sounds more like application design, apps using nHibernate to talk to the DB.
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 1:03 pm
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.
I think demos on the coolest (or the ones you know the most about!) features would work, especially in a hour talk.
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
August 25, 2016 at 1:08 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 didn't make it the whole way through, but I think most of them are horrible. I find it ironic that they can't spell the word "cache" and this is supposed to be authoritative. Based on my nausea with the answers, I must be completely unqualified.
August 25, 2016 at 1:18 pm
Ed Wagner (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 didn't make it the whole way through, but I think most of them are horrible. I find it ironic that they can't spell the word "cache" and this is supposed to be authoritative. Based on my nausea with the answers, I must be completely unqualified.
4.When are we going to use truncate and delete?
I like that the answer to this was somehow longer than, "When we want to remove data."
August 25, 2016 at 1:22 pm
BLOB_EATER (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 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.
Me personally I would prefer brief demos on each feature so then I would be comfortable to dive in on my own time.
I'd prefer the second option. Demos can get confusing with new features.
August 25, 2016 at 1:22 pm
ZZartin (8/25/2016)
Ed Wagner (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 didn't make it the whole way through, but I think most of them are horrible. I find it ironic that they can't spell the word "cache" and this is supposed to be authoritative. Based on my nausea with the answers, I must be completely unqualified.
4.When are we going to use truncate and delete?
I like that the answer to this was somehow longer than, "When we want to remove data."
The answer indicates they meant to ask what the difference between the two is, but with very amusing wording they seemingly perpetuated the myth that TRUNCATE is not logged:
In case of TRUNCATE, it will not store data in rollback gap and will unswervingly rub it out.
Sigh...
August 25, 2016 at 1:26 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 had to stop after number 12. There is no way that I am only deleting one duplicate at a time with the databases that I have.
Drew
J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA
August 25, 2016 at 1:35 pm
drew.allen (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 had to stop after number 12. There is no way that I am only deleting one duplicate at a time with the databases that I have.
Drew
At this point, it would be time to turn the tables and ask the interviewer "Tell me - what does RBAR mean to you?" and watch their reaction. Actually, it would be well past time, provided that you haven't thrown up yet.
August 25, 2016 at 1:44 pm
drew.allen (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 had to stop after number 12. There is no way that I am only deleting one duplicate at a time with the databases that I have.
Drew
Especially since using ROWCOUNT to control the number of rows for inserts and deletes has been deprecated since at least sql 2008 but IIRC as far back as 2005. Either way, a "definitive" answer using deprecated features is beyond suspect.
_______________________________________________________________
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 1:48 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 interview. I might not stop laughing, ever.
"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/
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:54 pm
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.
"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:56 pm
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. 😀
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:01 pm
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.
_______________________________________________________________
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/
Viewing 15 posts - 55,501 through 55,515 (of 66,712 total)
You must be logged in to reply to this topic. Login to reply