Hi,
that's right.
While working with In memory tables in SQL Server 2014 or later, We can get this queries raised, But what I'd mentioned is the basic difference between row store and column store indexes in SQL. If some one has better answers, I'd like to note down.
Besides, Can you please help me with flow chart of SSIS loading CSV file data to a fact table by coping dim table data.
Your response will be helpful.
To be brutally honest, these questions were asked by people that expect YOU to know the job they're trying to hire someone for. They're not expecting US to know the answers for you because we're not the ones that are going to be interviewed for the position you're applying for nor are we the ones they're going to have to put up with if you somehow get the job but can't do it. You need to hucker down and demonstrate that you know at least the first and most basic skill for any job in IT and that's how to search the web for information, find it, and then study it. None of these questions are so difficult that you can't do that.
The problem is that when you get to the interview, you won't be allowed to use the internet to answer the questions. You need to look at the description of the job and anticipate the questions they will ask and then prepare to be able to talk at length about any of the subjects listed on the job description.
If you can't do that, then your interview will be unsuccessful, or at least is should be if the interviewers are worth their salt.
And asking people to answer your interview questions for you is a despicable act.
Hi,
Knowledge means sharing. You should know this basic thing.
Irrespective of the working experience on a domain / technology , If a person with less experienced wants to know something and posting a query / questions in general forum, it'll get notified first and answered by the techies. this is a general thing I've seen so far.
From your latest post, I can understand you're not ready to share your thoughts on the queries. If so let others can share their answers here, So that the knowledge can be shared among ours.
Its not like I know something and I don't wanna disclose with you, If you're with this mindset, Please dont comment here and dont reply to my post.
If you're not ready to share your thoughts, I even post this queries and get the answers somewhere else, SQL has millions blogs around the world not like Oracle.
If I've posted some queries in this SQLServerForum, that doesn't mean that I dont know the answers.
It is like sharing knowledge and growing.
Hope you're able to understand what I mean Jeff Moden.
I also hope you understand what I mean. It's one thing to ask questions about things and I share a whole lot of information. But based on all the interviews that I've done over the years where people claim to be a DBA but have little understanding of the job or the skills required, I'll not help people that are cheating on a job interview and you, my friend, are cheating in the worst way possible. You're not even doing your own research, which is one of the most important traits of a DBA. Yes, we all need help once in a while and I've helped literally thousands of people but I'll not help you cheat to get a job. If you don't know something on an interview, be man enough to admit it because absolute honesty is also a super important trait of being a DBA or a Developer. Of course, you've just failed that litmus test, as well. You're a classic example of why I don't do email, Skype, or phone interviews and only do in person interviews.
I don't even need your help to get knowledge basically, I've already cracked the job. So let others to comment / share their knowledge here. Please do not reply hereafter.
I'm sharing some knowledge right now... You've just made my point. You shouldn't need any one's help to get knowledge during an interview. It should be all you because you're the one that has to eventually do the job. Worse yet, you keep trying to justify your cheating. You just failed the final test.