What is a table called, if it does not have neither Cluster
nor Non-cluster Index?
Answers were Sorted based on User's Feedback
Answer / debasish nanda
Unindexed table or Heap. Microsoft Press Books and Book on
Line (BOL) refers it as Heap. A heap is a table that does
not have a clustered index and, therefore, the pages are not
linked by pointers. The IAM pages are the only structures
that link the pages in a table together. Unindexed tables
are good for fast storing of data. Many times it is better
to drop all indexes from table and then do bulk of inserts
and to restore those indexes after that.
Is This Answer Correct ? | 0 Yes | 0 No |
What command is used to delete a table from the database in the sql server and how?
I have a table EMP in which the values will be like this EmpId Ename Sal DeptId 11 Ram 10000 10 11 Ram 10000 10 22 Raj 20000 20 22 Raj 20000 20 33 Anil 15000 30 33 Anil 15000 30 I want to delete only duplicate Rows. After Delete I want the output like this EmpId Ename Sal DeptId 11 Ram 10000 10 22 Raj 20000 20 33 Anil 15000 30
How can you insert null values in a column while inserting the data?
What is the dbcc command and why is it used?
What is save transaction and save point?
How do you delete duplicate rows in sql server?
What is database normalization?
7 Answers Deloitte, Digicel, JPMorgan Chase, Verifone,
How to encrypt data between dialogs?
How can you get @@error and @@rowcount at the same time?
Does group by sort data?
What is de-normalization in sql database administration? Give examples?
hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution