SQL Server Interview Questions
Questions Answers Views Company eMail

How many nested transaction can possible in sql server?

Bank Of America,

3 7057

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

1 3380

Advantages and disadvantages of stored procedures.

HCL,

2 5566




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,

1061

What is the difference between online clustering and Offline clustering?

IBM,

1227

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

IBM,

3 5950

What is the diffrence between update_one and auto_fix?

IBM,

3 6939

what are the advanced features in sql 2008?

Wipro,

2 3910




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 5461

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 8354

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

1 2039

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 2725

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 3648

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 4232

What is @@Identity in sql?

Cap Gemini,

1 4160


Post New SQL Server Questions






Un-Answered Questions { SQL Server }

in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it

313


where the connection string store in the database

819


Delete duplicate rows without using rowid.

191


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.

1351


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

854






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

361


what is checksum in sql server.........???

392


1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.

362


what is isolation level at dead lock?

1008


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

940


Scalability, Availability, Integration with internet, etc.)?

1648


What is the difference between NOROW and LOCKROW?

1293


What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

1151


Issues related in upgrading SQL Server 2000 to 2005 / 2008

767


how to overcome kernel isssues

468