1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category


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 8172

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

 2 3870

How will u get 5 years back record?

 5 8046

What is a materialized view?

 3 7160

What is MSDE?

 2 3991

How can you see what type of locks used?

 1 4096

What is transcation?Plz give One example?

 2 4082

Plz tell about backup&recovery?

 3 4318

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

3 16256

What is WITH CHECK OPTION

Karur Vysya Bank KVB,

3 8828

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 8672

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

ADP, Satyam, Tech Mahindra,

7 11828

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

Wipro,

5 9761

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

 1 3814

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

 2 3577

Un-Answered Questions { SQL Server }

What is difference between Datepart() and Datename() in SqlServer?

707

Tell me what is difference between view and materialized view?

509

How can you ensure that the database and sql server based application perform well?

619

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

854

Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

505




What is update_statistics command?

562

How to apply filtering criteria at group level with the having clause in ms sql server?

544

What is raid and what are different types of raid levels?

582

What happens if null values are involved in bitwise operations?

591

How to stop log file growing too big?

565

What are cascading parameters in ssrs reports?

176

What is the difference between a primary key and a unique key? Are they the same?

530

List all the types of user-defined functions?

510

What are unicode character string data types in ms sql server?

585

What are pages and extents? : SQL Server Architecture

545

For More Un-Answered { SQL Server } Questions Click Here