Answer Posted / kabir raj aryan verma

Full Form of XP is
eXperience as well as
eXtreme Programming.

What is the importance of three tier architecture?

1093

---

What are the filtered indexes?

1041

---

Define full outer join?

962

---

How to list all objects in a given schema?

1064

---

What do you mean by an execution plan?

1120

---

Difference between report and query parameter.

1103

---

What is the purpose of indexing?

1048

---

How to create a view on an existing table in ms sql server?

1135

---

What are ddl triggers and types of ddl trigger?

1040

---

how you can get the list of largest tables in a database? : Sql server administration

1058

---

Mention the differences between substr and charindex in sql server.

1058

---

Explain optimistic and pessimistic concurrency?

996

---

How to select true false based on column value in sql server?

1038

---

Explain the concepts and capabilities of sql server?

981

---

How to rebuild the master database?

1083

---