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