Answer Posted / guest

experience

Explain Capacity planning to create a database? and how to monitor it?

3766

---

When a primary key constraint is included in a table, what other constraints does this imply?

609

---

What is the difference between a fill factor of 100 and 0?

538

---

What does this statement do @@rowcount?

562

---

Name three of the features managed by the surface area configuration tool? : sql server security

520

---

---

What languages bi uses to achieve the goal?

520

---

Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

533

---

What is the dbcc command and why is it used?

579

---

How can you start sql server in different modes?

515

---

Explain comment on transactions?

564

---

What is factless fact table? : sql server analysis services, ssas

573

---

What is a unique key constraint?

539

---

How do I create a partition table in sql server?

505

---

How optimize sql query with multiple joins in sql server?

423

---

What is microsoft sql server?

546

---