Answer Posted / bijaylaxmi

sql>create bitmap index <bitmap index name>
on tablename(column name);
e.g-create bitmap index empbitmapjob on emp(job);
This is the syntax for bitmap index.

how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration

843

---

Can We Use Data-grids For Our Report In Ssrs?

177

---

Can you tell me about the concept of ER diagrams?

1017

---

How to fetch the next row from a cursor with a "fetch" statement?

1015

---

How do I start sql server agent automatically?

914

---

What is a non-clustered index?

950

---

List some major differences between triggers and stored procedures?

854

---

What is ms sql server service broker?

929

---

Difference between 2NF &3NF ?

1029

---

How to create a simple stored procedure in ms sql server?

973

---

How to disable triggers using "disable trigger"?

999

---

Explain what are commit and rollback in sql?

864

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

894

---

Explain error and transaction handling in sql server?

952

---

What is difference between stored procedure and user defined function?

1027

---