Interested to Buy Any Domain ? << Click Here >> for more details...
why cluster and non clusterindex are used in sqlserver 2000?
explain with example
- 1 Answers
- 4846 Views
- I also Faced
- E-Mail Answers
Answer / venkat
Index is commonly used for faster data retrieval.We can
have only one Clustered Index and many non-clustered index
in a single table.It is known that there is some
limitations in using indexes.If a column is defined as
primary key,by default column is set to be clustered
index.All other indexes created manually in the same table
were non-clustered index.
| Is This Answer Correct ? | 3 Yes | 1 No |
How to drop an existing schema in ms sql server?
Does index speed up select statements?
What is transaction server explicit transaction?
write the query for taking database backup in sql
10 Answers ABC, IBM, Logica CMG, MA,
How to return the second 5 rows in ms sql server?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?
What is 'write-ahead log' in sql server 2000 ?
Explain the usage of floor function in sql server.
What are the different types of joins and what does each do?
Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?
What is an index?
What is SCOPE_IDENTITY() in sql
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
