Answer Posted / yugal

SQL Server 2008 includes three general types of triggers:

1)DML triggers
2)DDL triggers
3)Logon triggers.

What is the data tier application?

145

---

How can you find out which stored procedures are recompiling?

524

---

Explain the properties of the relational tables?

563

---

What are the benefits of filtered indexes?

526

---

How do I find the port number for sql server?

508

---

---

What is sql server schema compare? How we can compare two database schemas?

575

---

How many joins in sql server?

532

---

Explain how would you store your query in an SSRS report or a Database server?

90

---

What are types of storage modes? : sql server analysis services, ssas

593

---

Where the sql logs gets stored?

552

---

What is the difference between count () and rowcount ()?

533

---

What are the types of database schema? : sql server analysis services, ssas

612

---

Can you name some of the dml commands in sql?

557

---

What will be the maximum number of indexes per table?

543

---

how you can move data or databases between servers and databases in sql server? : Sql server administration

493

---