Journey to SQL Authority with Pinal Dave

Posted in Pinal Dave, Readers Contribution, Readers Question, SQL, SQL Authority, SQL Documentation, SQL Download, SQL Interview Questions and Answers, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology | Tagged codeproject | 13 Comments

13 Responses

1. on March 19, 2010 at 7:09 am | Reply Roshan

   Hi Pinal,

   Absolutely, This is fantastic efforts and we are big fans of your interview questions and answers.

   Is there any way you can help us with other technology.

   Roshan

   
   
2. on March 19, 2010 at 7:10 am | Reply Jonathan Kehayias

   Pinal,

   While posting potential Interview questions and answers may help some people, it really makes my job as a interviewer that much harder because I have to then determine if someone really knows their stuff, or they just memorized the questions and answers from a list. I have started using lists such as these to know what questions to avoid in interviews, or to tailor my follow up questions to ensure that a person actually knows what they are talking about and not regurgitating responses they studied online.

   
   
   • on March 19, 2010 at 9:51 am | Reply pinaldave

     Hi Jonathan,

     This is excellent response, in fact I have been discussing it with few people here.

     Yeah I totally agree with you. If you have crossed SQL 101 there is no need to refer this questions at all. However, people any way search for them before going to interview and it is my attempt to them to find easy to single place, this way they can atleast read something and go to interview and instead of not read it and go.

     When I wrote it I was new to this field, now I am seeking help of community to add more value and more details to this questions. This way, they have more knowledge when they appear for interview. Expert like you will right away figure out if candidate has enough knowledge or have memorized Q and A.

     Kind Regards,
     Pinal

     
     
3. on March 19, 2010 at 1:12 pm | Reply Mark SQL

   Hi Jonathan,

   Good point but there are plenty of interview Q and A online, what is really interesting is that Pinal’s Q and A are much standard them all of them and we are confident about his content.

   I as interviewer use his Q and A to initially filter out bad candidates. If they do not know this Q and A, I will not spend my time with them any more.

   Mark

   
   
4. on March 19, 2010 at 1:12 pm | Reply Sudeepta

   Hello Pinal,

   Your question sets are really helpful. I have gone through question sets for SQL Server 2005 and learn some new things which I was not aware of earlier. Thank you for that.

   My question is, how should a person will start learning about performance tunning? Because the info present in a study guide or post doesn’t show up what exactly to be done. As i understand, this depends on a particular situation, is there any docs available through which a person can learn some more depth of the same.

   Thanks.

   
   
5. on March 19, 2010 at 1:20 pm | Reply Mark SQL

   Hi Jonathan,

   Please take my comment as other side and as healthy comment. I see your point here, it is I am using it for my purpose.

   Mark

   
   
   • on March 19, 2010 at 1:25 pm | Reply pinaldave

     Hi Mark,

     Jonathan is my very good friend and very respected person in community. I think your comments are not against him, it is your story.

     Those who are interested in can read his co-authored book here: http://blog.sqlauthority.com/2010/03/10/sqlauthority-book-review-professional-sql-server-2008-internals-and-troubleshooting/

     Thanks for comments.

     Kind Regards,
     Pinal

     
     
6. on March 19, 2010 at 6:51 pm | Reply Ramdas

   Hi Pinal,
   I have some questions in the SSIS area:
   1. What type of configurations do you use in the SSIS package (Answer: XML based Config,SQL Server Config these are the tow most used).
   2. What are the pros and cons of using one of the above methods.
   3. When would you use Lookup task in Data Flow in SSIS (Any downside to using this task?) – When using large tables using lookup task can be an issue. If the person has really used it one should know the pros and cons.

   Hope this helps…

   
   
7. on March 20, 2010 at 3:34 am | Reply ASHISH

   1) How you will configure your server if you have given chance as administrator to put them in production?

   2) Query taking 10 sec previously but now taking 2 sec. I want it back to 10 sec. how to achive?

   3) How to open dts(created in sql 2000) in 2008?

   few more to add but most of them are in or near to which already listed

   
   
   • on March 21, 2010 at 4:12 pm | Reply Vijaya Kadiyala

     Hi Ashish

     May be you want to re-visit your second question. :)

     If the query is taking 2 secs why would you want to make it wrost :)) LOL.

     
     
     • on March 22, 2010 at 9:31 am | Reply Imran Mohammed

       May be they want to create two positions.

       Current situation:
       Everything is Working fine.

       Job Position 1:
       Which can decrease performance and increase response time

       Job Position 2:
       To Perform Real DBA stuff…

       ~ Just for Fun.

       
       
     • on March 23, 2010 at 3:30 am | Reply ASHISH

       question to check either you aware of frepoolchache dbcc command…..

       
       
8. on March 20, 2010 at 8:04 am | Reply Amit Mathur

   Hi Pinal Sir,

   This is actually a great book.
   What I think is that these interview questions start from basics and then lead the readers directly on to the SQL 2008 Interview Questions. But in interview candidates are being asked for SQL 2005 questions also. Therefore I feel that if this book contains interview questions related to 2005 also in that case this book will become useful for everyone.