| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| How do you troubleshoot SQL Server if its running very slow? | | 2 |
| what purpose does OPENXML clause have in sql server stored
procedure? | | 1 |
| how insert selected column only ? | Robert-Half | 2 |
| How to tune a stored procedure? | | 5 |
| What is the advantage of specifying WITH GRANT OPTION in
the GRANT command? | | 2 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| What is mean by "fill factor" ? and what is mean
by "Index "in sql? | Logica-CMG | 1 |
| Explain the basic concepts of SQL server architecture? | | 2 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| How to find the date and time of last updated table?
| | 2 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 16 |
| Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases? | | 2 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | | 2 |
| What is data integrity? Explain constraints? | Thinksoft | 1 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| I Have Employee table having column name as ID,SALARY
how to get second max salary from employee table with id
ex
ID SALARY
1 20000
7 37000
2 5000 | | 11 |
| Hello all,
I have data like :-
year amt
2004 10
2005 20
2006 30
Now i want output as:-
2004 2005 2006
10 30 60
but i have to use here group by on year.So, i need a single
query within that i can find.
| | 2 |
| Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE) | | 1 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |