Here are few motivational quotes for candidates who are appearing for interview. I have collected this throughout the years and it is running list of the interview. Please feel free to let me know if you find any such good interview quote and I will update this list.
I like to do an interview when the other person isn’t expecting it. I find it’s more spontaneous. -Gregory Hines
One of the most important things, especially when you’re leaving school, is to realize you’re going to be dealing with a lot of idiots. And a lot of those idiots are in charge of things, so if you’re in an interview and you really want to tell the person off, don’t do it. -Lewis Black
A good engineering interview will include some set of difficult problems to solve. It might even require that the candidate write a short program. In addition, it will test the candidate’s knowledge of the tools she uses in great depth. -Ben Horowitz
Everything has changed. An interview has become such a confrontational thing. It makes you very defensive. -Francesca Annis
I walk on a stage, and I know if it’s been a good show or not. You know when it’s been a good interview. No one has to tell you. You know it. You feel it. You can feel the air. You can feel everything about it when it’s a good show. And you know when you’ve messed up. -Joan Rivers
I was completely unqualified to get into Harvard. But then I went to my interview for Harvard, and the woman asked, ‘Why do you want to go here?’ And I took out all of my comedy writing samples that I had done. I couldn’t have been more delusional in terms of what I thought they wanted in a candidate for college. -Mike Birbiglia
With every interview you feel like you lose a piece of yourself, and with every bad review you become just that little bit more bitter. It is horrible in a way. -Jane March
One of the hopes we have when we hear or read an interview with a mystery writer is to get inside the writer’s head, to learn something we didn’t know before. -Otto Penzler
Reference : Pinal Dave (https://blog.sqlauthority.com)
12 Comments. Leave new
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
Hi pinal,
Plz. answer these question.
q.1 what is dbcc sqlperf
q.2 what is dbcc errorlog
deepak kumar
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.
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
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.
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
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
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
hi
deepak kumar
q.5 what is dbcc sqlperf
q.6 what is dbcc errorlog
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
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.
Hi pinal,
Is it possible to debug the store procedure in sql server 2000.