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 5437

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

2 2653

How will u get 5 years back record?

5 5696




What is a materialized view?

3 5532

What is MSDE?

2 2424

How can you see what type of locks used?

1 2984

What is transcation?Plz give One example?

2 2697

Plz tell about backup&recovery?

3 2572




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

3 14132

What is WITH CHECK OPTION

Karur Vysya Bank KVB,

3 6961

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 5424

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 7668

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

Wipro,

5 7069

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

1 2627

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

2 2323


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

1618


What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

2676


how to use DTS package in 2000,2005,2008 in sql server

779


You are doing log shipping due to some reasons it is failing. How you will proceed from there

818


your distribution database is full what will u do

956






What is RMS migrations?

954


Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...

936


How we create SQL Server 2005 Reporting Services ? Give me Sample

920


role of sql sever 2005 in database rather than any other database

883


whats the maximum size of view state??

948


wat wil hapn if we give the both read and deny read permission to user?

931


Tell about MOM Tool(Microsoft Operator Manager)?

681


on line cluster can we make if yes tell me the procedure

837


Delete duplicate rows without using rowid.

191


Scalability, Availability, Integration with internet, etc.)?

1648