syntax and example for bitmap index in sql???

1 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  

---

If i am handling 150 servers then how to check the active jobs of all the servers?

0 Answers  

---

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

---

how to change column into row in sql

4 Answers   ESS,

---

---

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? : Sql server administration

0 Answers  

---

What is 1nf 2nf?

0 Answers  

---

What is sql server english query?

0 Answers  

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---

Tell me what is fill factor?

0 Answers  

---

What extended events?

0 Answers  

---

I Have Employee table having column name as ID,SALARY how to get second max salary from employee table with id ex ID SALARY 1 20000 7 37000 2 5000

17 Answers   HCL, IBM,

---