SQL Server Interview Questions
Questions Answers Views Company eMail

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

IBM,

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

What is WITH CHECK OPTION

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?

IBM,

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

Wipro,

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?

903


How to restore performance issues and how to check?

918


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

947


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?

690


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.

771






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

1559


Comment,Datatypes are unlimited

989


How you trouble shoot when any job fails

774


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

786


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

4373


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

4823


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

4791


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.

853


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

675


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?

947