Journey to SQL Authority with Pinal Dave

Posted in Data Warehousing, Database, Main, Pinal Dave, SQL, SQL Authority, SQL Download, SQL Error Messages, SQL Interview Questions and Answers, SQL Joins, SQL Performance, SQL Query, SQL Scripts, SQL Security, SQL Server, SQL Server DBCC, SQL Tips and Tricks, SQL Trigger, SQLAuthority Author Visit, T SQL, Technology | 28 Comments

28 Responses to “SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download”

1. on July 30, 2007 at 6:30 am Qumer Mumtaz

   hi
   Dave
   this is really comprehensive list of FAQs. Thank you for sharing ur knowledge.

   
   
2. on July 30, 2007 at 5:01 pm Top Posts WordPress.com

   [...] SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download Download Data Warehousing Interview Questions and Answers Complete List It was great pleasure to write latest series […] [...]

   
   
3. on July 30, 2007 at 7:57 pm Bart Czernicki

   Very good list of questions for general theory.

   However, employers seeking a candidate with a very good understanding of SQL Server Data Warehousing absolutely need to quiz the candidate on: SSIS, SSAS and performance tuning/indexing as well.

   
   
4. on August 11, 2007 at 3:36 am rajesh

   hello dave,
   i went thro your article regarding questions and answers in data warehouse. It s really good.

   
   
5. on August 14, 2007 at 2:21 am hitesh

   hi, please send me sql question and answer .i am very thankful to you.

   
   
6. on August 29, 2007 at 10:56 pm pankaj

   this is very good website for improving knowledge.

   
   
7. on September 7, 2007 at 2:20 am sunanda

   Please provide me the SQL Server DWH questions and answers.

   Thanks and Regards,
   Sunanda Kumar.

   
   
8. on September 12, 2007 at 12:46 am MADHU

   PLEASE PROVIDE DATAWARE HOUSING INTERVIEW QUESTIONS WITH ANSWER

   THANKS

   
   
9. on October 20, 2007 at 1:59 am Darshan

   Hello Sir

   My name is Darshan.
   I would like to know
   1) How to get the second maximum value , without using ’subquery’ ?
   2) How to find top 3 Salery/ Or any varing value without using ‘TOP function’?

   Thanks and Regards
   Darshan

   
   
10. on October 30, 2007 at 11:29 am SQL SERVER - Business Intelligence (BI) Basic Terms Explanation Journey to SQL Authority with Pinal Dave

    [...] Reference : SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download [...]

    
    
11. on November 9, 2007 at 5:08 pm Shareef

    Hi,
    I need FAQ on MS SS Analysis Services and Reporting Services. Cud u pl send it?
    thanks,
    Shareef

    
    
12. on November 20, 2007 at 10:33 am Deep

    Hi,
    Thanks for listing these questions/answers.
    Deep

    
    
13. on December 5, 2007 at 1:29 pm Dilip

    Realy fabulous materials…………

    
    
14. on December 19, 2007 at 12:22 pm Sandhya

    please tell me the basics of SQL

    
    
15. on December 22, 2007 at 7:16 pm Rajendra Uppal

    Hi, This is Rajendra, your material is really a lot of help to job seekers….thanks.
    ~rajendra.

    
    
16. on January 3, 2008 at 3:08 am R B Reddy

    This site is a ” Holly Bible” for Us, Thanks for your Help……..

    
    
17. on January 3, 2008 at 6:31 pm Amit

    Thanx Pinal
    its good to crack an interview

    ##@mit##

    
    
18. on February 12, 2008 at 5:35 pm omila

    Hi
    I need to find data warehouses developed for manufacturing organization (Apparel, etc) for decision making.

    I just need their business problem, why they selected data warehouse solution.
    I search for several days to get this info but i couldn’t.
    Its great help if anyone can send any links related to this. Sorry if this is not the correct place to publish this.. I’m really in need for this information.

    Thanks in advance.
    Omi

    
    
19. on February 19, 2008 at 5:59 pm Chandhra

    Excellent website…………. Thanx a TON……… Dave

    
    
20. on February 21, 2008 at 2:48 am Mickey

    Wonderful information! Thanks!

    
    
21. on April 1, 2008 at 8:33 pm Gouse

    Please send me the sql questions and answers.
    Please mail to this id.

    
    
22. on May 5, 2008 at 12:30 pm Radhakruhsna

    This is really good.

    
    
23. on May 9, 2008 at 12:46 pm ahamad

    Hi Friends,

    I am ahamad , i am new and i don’t know about knowledge datawarehousing. but i am interest in datawarehouse, at the time market want to which tools and interview calls are coming which moduels.

    My friend are said “Microstrategy” is a new at IT industrey. they told me you learn this tools .

    so i am confessed which one is better plz tell me , i need your help in my new life.

    byeee

    
    
24. on July 2, 2008 at 5:02 pm harikishan

    HI
    could anyone plz send the downloadable version of the BI FAQ
    Iwould be very thankful
    thank you
    harikishan

    
    
25. on July 31, 2008 at 10:16 am Shyam

    Hello Pinal,
    Can we update Primary key with to restore old record at the same id.
    regards
    Shyam

    
    
26. on August 16, 2008 at 3:07 am Suresh K V V

    Hi Pinal,

    I would be very thankful, if you can please share with us - any Faq’s available on SSAS, SSIS and SSRS in SQL2005.

    Regards,
    Suresh

    
    
27. on September 1, 2008 at 3:14 pm Truster

    Dave, this is a great post about Data warehousing with your series of questions and answers.

    I am currently working on my company’s database and would like to share my experience. I tend to use Open Source programs to manage my database: mainly Pentaho and Talend Open Studio.
    I prefer Talend Open Studio as it is user-friendly (I especially like the tmap component in Open Studio), has a good GUI and makes it possible to perform data integration without being an expert.
    The tool also has an active community able to help you out. Maybe you should try it?

    
    
28. on November 25, 2008 at 12:05 am praneeth

    thats a great job