Explain the dirty pages?

0 Answers  

---

You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  

---

Can the query output be sorted by multiple columns in ms sql server?

0 Answers  

---

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  

---

What are the types of model in sql server and explain

2 Answers   TCS,

---

---

What is the server name for sql management studio?

0 Answers  

---

What are the different authentication modes in sql server? How can it be changed?

0 Answers  

---

Can a table have 2 foreign keys?

0 Answers  

---

What do you understand by the data quality services in sql server?

0 Answers  

---

what's sql server? : Sql server database administration

0 Answers  

---

What purpose does the model database server?

0 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---