SQL Server Interview Questions
Questions Answers Views Company eMail

how to copy sysdatabase file from c: Drive to D: Drive in SQL Server.


6 5613

create index a on employee(dno) In this,which index was created?

2 2750

How will u get 5 years back record?

5 5890

What is a materialized view?

3 5656

What is MSDE?

2 2591

How can you see what type of locks used?

1 3082

What is transcation?Plz give One example?

2 2814

Plz tell about backup&recovery?

3 2722

How to find the date and time of last updated table?

3 14418


Karur Vysya Bank KVB,

3 7102

create procedure proc1 (@a int) as begin if @a=1 create table #temp(a1 int) else create table #temp(a1 int) end while executeing the above code it shows error like '#temp already exist' .why it shows an error?


8 5610

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

Satyam, ADP, Tech Mahindra,

7 7979

which query u can write to sql server doesn't work inbetween 7.00PM to nextday 9.00AM


5 7251

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 2754

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 2451

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

How do you Implement SSIS Packages in your Project?


How to restore performance issues and how to check?


Which is the best place or learning center for MS SQL?????In Bangladesh?????


How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?


i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.


Any one plz send me SQL Server Developer/DBA resume for 4 years experience


Comment,Datatypes are unlimited


How you trouble shoot when any job fails


sql database suspect We have a sql database that is showing as suspect. How can we recover?


Why we need to use secondry database file? though, we can do same work using primary database file also.


How can we call UDF(User Define Function) using C# code in ASP.net ?


If a stored procedure is taking a table data type, how it looks?


hi, how to link a text file and a .rpt file in my tables of sql server and to retrieve those records for further use. reply me as soon as possible.


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you


1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?