Answer Posted / chandan kumar

Select Top 1 salary from(select top 2 salary from emp_table
order by salary asc)

What does the on delete cascade option do?

1015

---

List out the different types of locks available in sql server?

976

---

can we have a nested transaction? : Sql server database administration

1084

---

How to change a login name in ms sql server?

1080

---

What happens if time-only values are provided as date and time literals?

1008

---

What is left outer join in sql server joins?

1037

---

What is the maximum size of column in sql server?

889

---

Write a SQL command to insert and update only a particular field?

1107

---

What is nolock hint in sql server 2008

1118

---

Mention the different authentication modes in sql server.

1044

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

6875

---

1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

2493

---

What are the different types of sql server replication? : sql server replication

1261

---

What are acid properties of transaction?

949

---

Which are the new data types introduced in sql server 2008?

879

---