How to populate a table in sql server?

0 Answers  

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---

What are the benefits of filtered indexes?

0 Answers  

---

Can foreign key be duplicate?

0 Answers  

---

Write an sql query to find the names of employees start with ‘a’?

1 Answers  

---

---

Tell about MOM Tool(Microsoft Operator Manager)?

0 Answers  

---

Can sql server be linked with other servers like oracle?

0 Answers  

---

Explain the dbcc pintable command when would you use it?

0 Answers  

---

How to assign new column names in a view?

0 Answers  

---

How to stop a loop early with break statements in ms sql server?

0 Answers  

---

What is the use of DBCC commands?

4 Answers   NA,

---

If there exist a index on the table, and we then make a view on that table (include the indexed column from base table) than why do we require indexing on view?Doesnt it create an overhead?

2 Answers  

---