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 3686

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

1 2049

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

3 2435




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?)

744

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,

980

what is isolation level at dead lock?

Verizon,

1047

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

Verizon,

1 2896

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

751




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

698

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

IBM,

2 3013

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

860

Working with TLogs

717

How you trouble shoot when any job fails

729

How to trouble shoot if unable to connect SQL Server

810

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

884


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

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

4302


how to overcome kernel isssues

497


hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

1180


whats the maximum size of view state??

986


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

872






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

4760


How do you Implement SSIS Packages in your Project?

869


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.

1289


Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.

1387


can any body tell me how to know the password of current user in sql server

947


Delete duplicate rows without using rowid.

231


how can you select rexcord(rows) from table A which is not present in Table B . Id being the FK in Table B referencing to ID Table A

406


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1081


what are the Prerequisites for Replication?

8605


How retrieve field names from the table in SQL through JAVA code?

741