| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| The Difference between 'Count' and 'Count(*)' | | 12 |
| What is blocking and how would you troubleshoot it? | | 1 |
| how to change column into row in sql | ESS | 2 |
| What is the use of MOVE keyword in restore command | IBM | 2 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | HCL | 4 |
| What's the maximum size of a row? | | 4 |
| What's the difference between a primary key and a unique
key? | | 4 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| What are the different types of replication? How are they used? | | 3 |
| What is a view? | | 4 |
| what are batch in sql server?
| Satyam | 2 |
| to explain sql server 2000 architecture & authentication | | 1 |
| What is the difference between login and a user? | TCS | 7 |
| How do SQL server 2000 and XML linked? | | 2 |
|
CLR Integration ?
what is Notification services ?
| Satyam | 1 |
| Different Types of Functions ?
| Satyam | 2 |
| How can u convert the Date to String? | TCS | 4 |
| What are the two types of concurrency? | | 2 |
| From where can you change the default port? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |