Click here to Skip to main content
15,920,956 members
Home / Discussions / Database
   

Database

 
AnswerRe: How to acccess the SQL database over a network Pin
ozzyrocsdbn3-Jul-07 1:11
ozzyrocsdbn3-Jul-07 1:11 
GeneralRe: How to acccess the SQL database over a network Pin
originSH3-Jul-07 1:19
originSH3-Jul-07 1:19 
QuestionHow can i embed SQL Server 2000 system???? Pin
john84vn2-Jul-07 21:29
john84vn2-Jul-07 21:29 
AnswerRe: How can i embed SQL Server 2000 system???? Pin
Ed.Poore2-Jul-07 22:28
Ed.Poore2-Jul-07 22:28 
AnswerRe: How can i embed SQL Server 2000 system???? Pin
ronp3-Jul-07 13:48
professionalronp3-Jul-07 13:48 
GeneralRe: How can i embed SQL Server 2000 system???? Pin
john84vn4-Jul-07 5:47
john84vn4-Jul-07 5:47 
QuestionIndexes........ Pin
Xandip2-Jul-07 21:04
Xandip2-Jul-07 21:04 
AnswerRe: Indexes........ Pin
Rahul.Goel2-Jul-07 21:40
Rahul.Goel2-Jul-07 21:40 
Hello Sandeep,

Indexes are created for faster retrival of data. Its like searching a topic in a book with the help of index in book. Imagine if have to search the topic in a book without an index. It will be slower as you have to browse through each an every page to check for the topic.

Indexes are of two types

1) Clustered index

2) Non clustered index.

For more information about these two type index you can check books online of sql server

Everytime you create a primary key using enterprise manager, it by default creates a clustered index. But thats not mandatory. You can have a primary key without any index.
Its because its recommened to have a clustered index on a unique column.

I hope I answered your question.

please let me know incase of any query.



Rahul Goel
Microsoft Cerfied Solution Developer .Net
Contact me at : rahul.g2510@gmail.com

GeneralRe: Indexes........ Pin
Xandip2-Jul-07 23:48
Xandip2-Jul-07 23:48 
GeneralRe: Indexes........ Pin
Pete O'Hanlon3-Jul-07 0:22
mvePete O'Hanlon3-Jul-07 0:22 
QuestionTNS error Pin
kvijayajyothy2-Jul-07 18:16
kvijayajyothy2-Jul-07 18:16 
AnswerRe: TNS error Pin
Sathesh Sakthivel2-Jul-07 18:45
Sathesh Sakthivel2-Jul-07 18:45 
QuestionData Table and Data View Questions Pin
HurricaneDan2-Jul-07 15:15
HurricaneDan2-Jul-07 15:15 
QuestionSQL 2005 Remote Connection Error Pin
Amit Kumar G2-Jul-07 15:04
Amit Kumar G2-Jul-07 15:04 
AnswerRe: SQL 2005 Remote Connection Error Pin
Sathesh Sakthivel2-Jul-07 16:25
Sathesh Sakthivel2-Jul-07 16:25 
AnswerRe: SQL 2005 Remote Connection Error Pin
Sgg2453-Jul-07 1:26
Sgg2453-Jul-07 1:26 
QuestionWhy is it called "Hibernate"? Pin
David Veeneman2-Jul-07 12:59
David Veeneman2-Jul-07 12:59 
AnswerRe: Why is it called "Hibernate"? Pin
originSH2-Jul-07 22:34
originSH2-Jul-07 22:34 
QuestionScript-generating commands? Pin
PIEBALDconsult2-Jul-07 10:20
mvePIEBALDconsult2-Jul-07 10:20 
AnswerRe: Script-generating commands? Pin
Mike Dimmick2-Jul-07 11:01
Mike Dimmick2-Jul-07 11:01 
GeneralRe: Script-generating commands? Pin
PIEBALDconsult2-Jul-07 11:45
mvePIEBALDconsult2-Jul-07 11:45 
QuestionDifference between sql server 2000 and 2005 Pin
Malayil alex2-Jul-07 8:16
Malayil alex2-Jul-07 8:16 
AnswerRe: Difference between sql server 2000 and 2005 Pin
Pete O'Hanlon2-Jul-07 9:40
mvePete O'Hanlon2-Jul-07 9:40 
AnswerRe: Difference between sql server 2000 and 2005 Pin
leckey2-Jul-07 11:45
leckey2-Jul-07 11:45 
QuestionSubquery returned more than 1 value Pin
Sam Heller2-Jul-07 5:47
Sam Heller2-Jul-07 5:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.