| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to find nth highest salary | NexGen | 30 |
| How do you know which index a table is using? | | 4 |
| what is maximum size of temp db? | iSoft | 4 |
| create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end
while executeing the above code it shows error
like '#temp already exist' .why it shows an error? | IBM | 5 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | HCL | 2 |
| There is table like Events...in that name ,startdate
,enddate,location are the column names
write a stored Procedure for this table to get events by
Months "GetEventsByMonths" | | 1 |
| How to tune a stored procedure? | | 5 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| How do you use DBCC statements to monitor various aspects of
a SQL server installation? | | 1 |
| write the query for taking database backup in sql | Logica-CMG | 6 |
| How will u get 5 years back record? | | 4 |
| 1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
| | 3 |
| What do you mean by COLLATION? | | 4 |
| How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table? | Leo-Technologies | 12 |
| How do you measure the performance of a stored procedure? | Infosys | 1 |
| Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table? | eFunds | 5 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| What are the different types of replication? How are they used? | | 3 |
| What is the difference between temp table and table variable? | Microsoft | 4 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
