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 5358

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

2 2611

How will u get 5 years back record?

5 5618




What is a materialized view?

3 5464

What is MSDE?

2 2355

How can you see what type of locks used?

1 2920

What is transcation?Plz give One example?

2 2650

Plz tell about backup&recovery?

3 2464




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

3 14017

What is WITH CHECK OPTION

Karur Vysya Bank KVB,

3 6888

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 5359

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 7584

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

Wipro,

5 6995

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

1 2574

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

2 2264


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

1275


where the connection string store in the database

790


how can you attach more than 20 ldf files in sql server

802


how to do partition in sqlserver

1279


Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

899






how to take backup bcp out for a column in table in sql server?

820


what are the Prerequisites for Replication?

8344


what is isolation level at dead lock?

988


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

1072


1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

827


How to trouble shoot if unable to connect SQL Server

744


What is the difference between NOROW and LOCKROW?

1233


how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

1036


how can u get last observation in an unknown dataset ?

1107


What is the difference between online clustering and Offline clustering?

1197