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.

Syntax to find the used space and free space of the Data file in a database(SQL Server). Following queries didn't give the exact Used space and Free Space Information sp_spaceused;DBCC showfilestats;exec MyDbName.dbo.sp_spaceused;SP_HELPFILE Can any one tell me the query for how to find the exact used data file space and free space in a Data File?

2 Answers   Cognizant,

---

Explain encryption of entire databases without the need for application changes in sql server 2008?

0 Answers  

---

Is the log file is a part of file group?

0 Answers  

---

What is difference between foreign key and unique key?

0 Answers  

---

Explain about remote stored procedure?

0 Answers  

---

---

How to delete duplicate records based on single column from a table?

0 Answers   Petranics Solutions,

---

What is a stored procedure?

3 Answers  

---

What is a Lock and let me know Different types of locks?

2 Answers  

---

What is history table in sql server?

0 Answers  

---

Explain the types of indexes.

0 Answers   Accenture,

---

What is the security model used in sql server 2005?

0 Answers  

---

Why truncate is ddl?

0 Answers  

---