SQL Server Interview Questions
Questions Answers Views Company eMail

Find 2nd Highest salery in emp table Select* from emp where &n= select * count from emp where (salery >=emp.salery) Enter n value 2 These query is correct or not. Tell me any other methods.

6 3412

What is the maximun sixes of .mdf in sql server 2005

1 1945

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 2278




Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

669

after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

Verizon,

908

what is isolation level at dead lock?

Verizon,

968

what r steps to we need to fallow b4 kill the process?

Verizon,

1 2781

If the job running very slow what is the action you do

663




IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do

612

What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue

IBM,

2 2878

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

771

Working with TLogs

640

How you trouble shoot when any job fails

629

How to trouble shoot if unable to connect SQL Server

725

If user is owning any SQL Objects, can we drop that user

812


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

2579


how to overcome kernel isssues

435


SQL Server Architecture ?

1080


explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?

1192


how many no of arguments can be passed in procedures and functions

3421






after migrating the dts packg to ssis by using migrtn wizrd in 2005. iam not able to open ssis pack and getting error. what r those errors? how to resolve?

908


Tell about MOM Tool(Microsoft Operator Manager)?

634


How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

2628


I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

616


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

1047


tell me the disaster recovery plan

1237


Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.

1217


How you trouble shoot when any job fails

629


System variable and temporary variables

928


How to convert a table data in XML format in sql server?

1351