ssis and ssrs interview questions

Question

ssis and ssrs interview questions

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

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

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 1

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

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

Randheer SSC Eights! Points: 985 More actions · Answer 3

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

Jeff Moden SSC Guru Points: 1004304 More actions · Answer 4

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)

Randheer SSC Eights! Points: 985 More actions · Answer 5

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

patricholier Grasshopper Points: 11 More actions · Answer 6

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.

Phil Parkin SSC Guru Points: 246955 More actions · Answer 7

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?

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

KatieAndEmil SSC Eights! Points: 843 More actions · Answer 8

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

KatieAndEmil SSC Eights! Points: 843 More actions · Answer 9

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

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 10

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

KatieAndEmil SSC Eights! Points: 843 More actions · Answer 11

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?

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 12

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

veera.1255 SSC Enthusiast Points: 137 More actions · Answer 13

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....

KatieAndEmil SSC Eights! Points: 843 More actions · Answer 14

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

veera.1255 SSC Enthusiast Points: 137 More actions · Answer 15

veera.1255

SSC Enthusiast

Points: 137

May 21, 2011 at 10:09 pm

#1328156

thank u for ur answer