| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Differnce between sel server 2000 and 2005 | | 3 |
| 1.Describe way(s) to tune the SQL table in order to
optimize performance.
2. Explain SQL Injection and how can you prevent them? | Techno-Solutions | 1 |
| How can you get @@error and @@rowcount at the same time? | | 4 |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| What is transaction ? Give me one example. | Melstar | 7 |
| SQL stops working in every 15 days displaying message that
database log file is full. Log file size is 3.95 GB. It is
happening after shrinking the database also. What is
solution to overcome this problem. Please help me as it's
urgent. | | 2 |
| 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 | | 10 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| What are the magic tables in SQL Server 2000? | Infogain | 5 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 1 |
| difference between sql server2000 and sql server2005
| | 1 |
| How do SQL server 2000 and XML linked? | | 1 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 1 |
| explain different types of jions with examples briefly? | Zensar | 1 |
| what is physical sort data and logical sort data in index? | | 1 |
| What's the maximum size of a row? | | 4 |
| When do you create cluster and noncluster index? | Satyam | 4 |
| what is the main difference between constraints(like
primary key etc..)& joins? | Annik | 2 |
| How to write stored procedure to update the data in 10
tables | | 3 |
| How To delete duplicate record from a particular table? | eXensys | 8 |
| |
| For more SQL Server Interview Questions Click Here |