SQL Server Interview Questions
Questions Answers Views Company eMail

Why do you want to join software field as you have done your BE in Electronics?

HCL, Cap Gemini,


what is sql injection?

2 3184

Can we passed multiple recordset(set of records) using a Stored Procedure

2 2826

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.



How to Install SQL SERVER 2005 remotely?


1 2569

what are the Prerequisites for Replication?


1 8233

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?


2 6521

How many jobs will create for Mirroring, Log Shipping, and Transactional Replication?


4 11574

After the SQL installation what are the jobs will you configure?

IBM, Satyam, G7 CR Technologies,

1 2394

If i am handling 150 servers then how to check the active jobs of all the servers?


An employee table, with the columns id, name, sal and dob. Query to select emp names of all highest salaries(there are 4-5 people having the same salary which happens to be the highest).


9 8078

I have cleared sbi clerk examination. I am Bachelor in computer application (BCA) graduate. so which type of question related bca in sbi clerk interviews. pls answers me at sejalvaghela@yahoo.co.in.. and also tell me which type of question asked in sbi clerk interview.

1 3433

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions


difference between select column name from table name where serviceid=2; and select max(column name) from table name where serviceid=2; IN ORACLE

Intel, Wipro,

3 4548

1. How to fetch all the duplicate records from the table. 2. How to fetch the second highest salary from the table.


11 10766

Post New SQL Server Questions

Un-Answered Questions { SQL Server }

Explain Capacity planning to create a database? and how to monitor it?


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?


What is the difference between NOROW and LOCKROW?


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., }


SQL Server Architecture ?


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?


what is the sql equivaent of the dataset relation object ?


In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram


query processing


What is the difference between online clustering and Offline clustering?


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


Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .


You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?


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 ?


what are the critical issues you have resloved in your company