Post reply

ssis and ssrs interview questions

  • February 2, 2011 at 11:52 pm

    #1281735

    Jeff Moden (2/2/2011)

    parmar.randheer11 (1/30/2011)

    Hi,

    I have consolidate few SSRS and TSQL questions for interview on my blog http://SQLServerQuest.blogspot.com .

    you can check SSRS interview questions from there.

    Thanks

    Randheer

    I got just a couple of questions in before I found this...

    [font="Arial Black"]What is the difference between char and varchar?[/font]

    Char is used for character data types and varchar is used for string data types it can handle spaces between names also.

    I strongly suggest you review the answers for your questions. 😉

    I also got few questions 😉

    Different types of report?

    Your answer: TLSQ...yes "TLSQ" report and MDX Report

    Please revise the content

    Raunak J

  • February 3, 2011 at 12:18 am

    #1281738

    Jeff Moden (2/2/2011)

    parmar.randheer11 (1/30/2011)

    Hi,

    I have consolidate few SSRS and TSQL questions for interview on my blog http://SQLServerQuest.blogspot.com .

    you can check SSRS interview questions from there.

    Thanks

    Randheer

    I got just a couple of questions in before I found this...

    [font="Arial Black"]What is the difference between char and varchar?[/font]

    Char is used for character data types and varchar is used for string data types it can handle spaces between names also.

    I also ran into this...

    [font="Arial Black"]What is the table variable?[/font]

    Table variable is the variable used to store data in table form. It like temporary table but it scopes remains till the execution of the query only. It a variable so no index can be created on it.

    I strongly suggest you review the accuracy of the answers for your questions. 😉

    I think he is purposely putting fake answers there. This way, people will fail their job interviews, so that he can take the job!

    A true masterplan!!!

    😀

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 3, 2011 at 9:19 am

    #1281986

    Hey,

    I don’t want to take others opportunity 🙂 I am not job less :-). I know some answers are not up to marks I am correcting those and definitely working on answers accuracy.

    Anyway no one can give an answer in interview on basis of 3 lines which I will put there. It will give just an idea about questions for cracking the interview.

    People need to read the books online to deeply understand the concept.

    Randheer Singh

    ----------------------------------
    CheckOut My Blog for SQL Server Realated Topics and Interview Questions for SSIS , SSRS and TSQL.

    http://www.sqlserverquest.com/p/ssrs-interview-questions.html
    http://www.sqlserverquest.com/p/ssis-interview-questions.html
    http://www.sqlserverquest.com/p/tsql-interview-questions.html

  • February 4, 2011 at 6:58 am

    #1282430

    parmar.randheer11 (2/3/2011)

    Hey,

    I don’t want to take others opportunity 🙂 I am not job less :-). I know some answers are not up to marks I am correcting those and definitely working on answers accuracy.

    Anyway no one can give an answer in interview on basis of 3 lines which I will put there. It will give just an idea about questions for cracking the interview.

    People need to read the books online to deeply understand the concept.

    Thanks for taking my comments the right way, Parmar. Well done.

    Still, you have to understand that I'm dead set against posting interview questions especially with answers because I agree with your last statment above. People need to learn SQL Server to pass an interview on SQL Server. 🙂

    I guess that's why I've never really done an interview simply by asking only rote questions. I interact with the interviewee and find out what makes that person tick and how they think when it comes to SQL. I typically sit next to the person so I can write stuff on a piece of paper and then slide the pad over to them so they can "think" on the paper.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • February 9, 2011 at 9:22 am

    #1284586

    1

    Randheer Singh

    ----------------------------------
    CheckOut My Blog for SQL Server Realated Topics and Interview Questions for SSIS , SSRS and TSQL.

    http://www.sqlserverquest.com/p/ssrs-interview-questions.html
    http://www.sqlserverquest.com/p/ssis-interview-questions.html
    http://www.sqlserverquest.com/p/tsql-interview-questions.html

  • April 21, 2011 at 7:53 am

    #1314525

    Hi

    I found that a member asked same question in this forum some months ago.

    Pls use search box to find this questions with comments

    If you want to get more materials that related to this topic, you can visit: Administrative interview questions and answers[/url]

    Best regards.

  • April 21, 2011 at 8:07 am

    #1314537

    patricholier (4/21/2011)

    Hi

    I found that a member asked same question in this forum some months ago.

    Pls use search box to find this questions with comments

    Same as what?

    To whom are you directing this comment?

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • May 18, 2011 at 11:23 pm

    #1326889

    Here are some SSRS Interview questions and answers http://www.sql-server-business-intelligence.com/sql-server/ssrs/ssrs-interview-questions-and-answers-pdf-download

  • May 20, 2011 at 5:52 am

    #1327577

    http://www.sql-server-business-intelligence.com/sql-server/ssrs/ssrs-interview-questions-and-answers-pdf-download

    http://www.sql-server-business-intelligence.com/sql-server/ssis/ssis-interview-questions-and-answers-pdf-download

  • May 20, 2011 at 6:15 am

    #1327594

    Question: Gives examples where you used parameters?

    Comment: Typically you use parameters to filter data in datasets (or data on reports) but you can also use them to restrict values like the well-known make->model->year example. You can also have hidden and internal parameters which get very handy for more advanced stuff.

    This doesn't belong in the SSIS section.

    I must say I found your site better than most "SQL interview questions". The questions you present are not simple question/answer pairs you need to memorize before an interview, but questions that invite the reader to think more about what they are going to say in the interview.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • May 21, 2011 at 4:06 am

    #1328089

    I'm glad you like that questions I tried to make them 'open' as anyone can learn questions and answers but not everyone knowns reasons why one way is better over another one which usually results in following or creating best practise.

    I admit I have first written SSRS questions and then copy/paste and change the questions....l I missed this one. I replaced it with another one (business rules).... Also one

    thing makes me wonder... any particual reason why you decided to post the reply here and not on my website? I like user feedback which allows me to re-think what I'm doing it (like yours) but I get few comments.... maybe it is not so easy to spot it on my website?

  • May 21, 2011 at 5:52 am

    #1328092

    emil 94400 (5/21/2011)

    I'm glad you like that questions I tried to make them 'open' as anyone can learn questions and answers but not everyone knowns reasons why one way is better over another one which usually results in following or creating best practise.

    I admit I have first written SSRS questions and then copy/paste and change the questions....l I missed this one. I replaced it with another one (business rules).... Also one

    thing makes me wonder... any particual reason why you decided to post the reply here and not on my website? I like user feedback which allows me to re-think what I'm doing it (like yours) but I get few comments.... maybe it is not so easy to spot it on my website?

    There's no particular reason why I posted my comment here and not on your website 🙂

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • May 21, 2011 at 7:22 am

    #1328099

    hi this is veera.

    i am new to ssrs 2008.

    whats the meaning of dynamic report?

    that any one can send the answer to me....

  • May 21, 2011 at 11:10 am

    #1328119

    Hi veera

    Dynamic report depends who you ask.

    Dynamic might mean also interactive... like interactive sorting on columns, like expand/collapse option (toggle items), or adjustable report depending on content (like chart intervals)

    It might also refer to filters you have. You can display different content based on different filter selection which might be considered dynamic, you can also dynamically create data sets using expressions (which is commonly called "dynamic SQL")

    This on is not particularly easy to answer my answer would be.... a can think of several different things which relate to dynamic reports however I would like to answer your question best as I can. So would you be able to clarify what you mean by saying dynamic report? ..... The person will most likely clarify the question....or ask you to tell everything you know (if they don't know themself).

    Hope that helps

    Emil

  • May 21, 2011 at 10:09 pm

    #1328156

    thank u for ur answer

Viewing 15 posts - 106 through 120 (of 163 total)

You must be logged in to reply to this topic. Login to reply