SQLAuthority News – Find Job Related to SQL Server and Database Administrator and Interview Questions and Answers

It is real pleasure for me when I learn that reader of my blog has got something good out of this blog. Please read following abstract of one of the recent email I received.

“Dear Dave,

I am very thankful to you for wonderful blog. I do not know how can I repay you for all the favors you have done to me. I read your blog everyday but one post I got most out of is Interview Q and A. I have memorized them very well. I was able to find job related as Database Architecture in Portland from your job listing.

You must visit me at Portland and be my guest.

Name of Blog Reader.”

This kind of e-mail makes my day, rather makes my whole efforts. I have displayed only part of this email. I promised to him that I will be his guest when I visit Portland. I wish best to my readers.

Reference in email : SQL Authority Job Site, SQL Authority Interview Questions and Answers, SQL Authority Generic Interview Questions

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

12 thoughts on “SQLAuthority News – Find Job Related to SQL Server and Database Administrator and Interview Questions and Answers

  1. Hi Dave,
    Good morning.
    I went for an interview he asked me so many typical question. could u give me the answer these question?

    Q1. U have 100 databases sizes of (100mb, 500 mb, 120mb, 10 mb) The question is how do u get the ascending order of these databases for example first 10mb, 100mb, 120mb and 500mb and so on). and how can u create a strored procedure to backup these databases.

    q.2 u have 100gb of database named xyz.bak how can u restore it when u don’t have any space to check whether this file is ok or not?

    q.3 how can u restrict a user to run profiler though revoking his server role permission. Suppose u have one user named dave and I want to revoke his permission so that he can’t run the profiler.

    q.4 what is schema in SQL Server 2005.

    Plz. answer these question.

    Deepak Kumar

  2. HI Pinal Dave,

    Plz. answer these questions.
    I went for an interview he asked me so many typical question. could u give me the answer these question?

    Q1. U have 100 databases sizes of (100mb, 500 mb, 120mb, 10 mb) The question is how do u get the ascending order of these databases for example first 10mb, 100mb, 120mb and 500mb and so on). and how can u create a strored procedure to backup these databases.

    q.2 u have 100gb of database named xyz.bak how can u restore it when u don’t have any space to check whether this file is ok or not?

    q.3 how can u restrict a user to run profiler though revoking his server role permission. Suppose u have one user named dave and I want to revoke his permission so that he can’t run the profiler.

    q.4 what is schema in SQL Server 2005.

    q.5 what is dbcc sqlperf
    q.6 what is dbcc errorlog

    Plz. answer these questions.

  3. hi Pinal Dave,
    ur website is the best

    i’m having a problem in sqlserver 2005
    simply when i try to select data from table
    containing 800,000 rows its tacking infinite time
    i checked the keys and the indexes of the table but nothing seems to be wrong

    even if i try a simple select statment with where conditions also it’s tacking infinite time

    hope u can help me

    thnx

  4. I’m glad to see this person got a job, but I wonder how much of an asset they will be in their new role based on their needing to “memorize them very well” – regarding your Q&A. I see that all too often, someone that can memorize, but cannot create, or design, or act with initiative on that memory.

  5. To Pinal,

    You have changed my life as well. I read your questions and got the job, today I am Jr. Manager in less than one year in MNC based in Pune.

    To Jason,
    It is not true, Pinal’s questions and answers are very well explained and teaches everybody in great detail. I think just reading them one learns so much that interview is just piece of cake.

    Radhe

  6. hi ,

    I am suresh from chennai, currently i am working Dotnet past 18 months , Last week i attend one interview they ask , how to debug your storedprocedure in sqlserver 2000 ? i am anable to answer , any one able to help me how to debug the stored procedure, if you are interested to send mail pls send me.

    thanks ,

    suresh

  7. hi pinal,
    its really great to read.
    precently i am working in java with sql server.
    but i am very intrested to work in sql server. so i want to swithover from java to sql server.

    suggestion please.
    thanx and regards
    dheena

  8. hi
    deepak kumar

    what is dbcc sqlperf
    :- this command use to check the log space in your database log file ex . dbcc sqlperf(logspace)

    what is dbcc errorlog
    :- Recovery of database

  9. Here is the full command,

    DBCC SQLPERF (LOGSPACE) WITH NO_INFOMSGS

    Pls. run this in Query Analyzer and see the output yourself – its straight forward & simple. In 2005 they have added some more options, pls. try them as well, of course NOT on production system.

    Before asking any questions pls. refer to Book Online.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s