What is standby servers? Explain types of standby servers.

0 Answers  

---

what are triggers? : Sql server database administration

0 Answers  

---

What is difference between inner join and full join?

0 Answers  

---

What do you understand by physical_only option in dbcc checkdb?

0 Answers  

---

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

---

---

you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

What are different types of collation sensitivity?

0 Answers  

---

when inserting to a table how many rows will be effected using triggers

2 Answers  

---

What is normalization of database? What are its benefits?

0 Answers  

---

What does set rowcount do?

0 Answers  

---

What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

0 Answers  

---

How to declare and use cursor variables?

0 Answers  

---