Answer / 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.

What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

1 Answers  

---

Do you know the cursor optimization tips?

0 Answers  

---

What is log in sql server?

0 Answers  

---

Does index slows down insert statements?

0 Answers  

---

What are the different types of stored procedures?

0 Answers  

---

Do you know what is sql service broker?

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

2 Answers   HCL,

---

Well sometimes sp_reanmedb may not work you know because if some one is using the db it will not accept this command so what do you think you can do in such cases?

2 Answers  

---

Detail about the hardware which is supported by SQL server?

0 Answers  

---

How do clustered indexes store data?

0 Answers  

---

What do you understand by a view? What does the with check option clause for a view do?

0 Answers  

---

Do you know how to make remote connection in database?

0 Answers  

---