Interested to Buy Any Domain ? << Click Here >> for more details...
What is a table called, if it does not have neither Cluster
nor Non-cluster Index?
- 2 Answers
- 9523 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the kinds of subquery?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What is the osql utility?
Explain various On-Delete options in a DB table. Which is the default option?
Explain the properties of sub-query in sql server?
What do we have to check in database testing?
How to define the name and server for a new dsn?
Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?
How to create user messages with print statements in ms sql server?
What are the dis_advantages of stored procedures, triggers, indexes?
Explain different types of self contained sub query?
What are parameterized reports?
What does the not null constraint do?
What is function of ROLLUP ?
