SQL Server Interview Questions
Questions Answers Views Company eMail

How many nested transaction can possible in sql server?

Bank Of America,

3 6986

hi,i want t0 knom d syntax for a super key with an example

1 3339

Advantages and disadvantages of stored procedures.

HCL,

2 5506




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

HCL, Wipro,

1036

What is the difference between online clustering and Offline clustering?

IBM,

1197

When do u use clustered index and non-clustered index?

IBM,

3 5885

What is the diffrence between update_one and auto_fix?

IBM,

3 6814

what are the advanced features in sql 2008?

Wipro,

2 3866




Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC

2 5390

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 8200

two tables with table name ship(name,year) and battle (name,year),how to find the latest added year in the table ship

1 1995

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 2686

select name of emplyoee whose total salary is 130 from following table. id name salary 1 a 100 2 b 20 3 c 50 1 a 30 2 b 70 Post the resulantant Query?

7 3581

here id col have primary key and identity id name 1 a 2 b 3 c 4 d delete 2nd row then o/p will be id name 1 a 3 c 4 d next inssert 2nd row and i want o/p will be id name 1 a 2 e 3 c 4 d

IBM, TCS,

7 4171

What is @@Identity in sql?

Cap Gemini,

1 4103


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

SQL Server Architecture ?

1103


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

564


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

996


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

630


your distribution database is full what will u do

927






OPTIMIZATION OF SP,CURSOR,TRIGGERS

1481


what are the critical issues you have resloved in your company

789


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

642


where the connection string store in the database

790


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

895


How should i optimize the time for execution of stored procedure having single input and many output from the different tables?

790


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.

1321


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

1118


whats the maximum size of view state??

914


How to restore performance issues and how to check?

813