Click here to Skip to main content
15,921,203 members
Home / Discussions / Database
   

Database

 
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 
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 
Xandip wrote:
Indexes should be only used in tables used for data retrieval and not in tables where frequent INSERT & UPDATE take place.
When an Index is created over a table, then there is no need for defining a PrimaryKey for that table.
Indexes are best suited for Views.


No. Indexes can be used in tables which perform frequent insert/update/deletes. They are used to speed up retrieval of information, so if you need to select information from these tables you should consider whether or not they should be used.

A primary key is not intended to act as an index. Just because a primary key normally has an index associated with it does not mean that having an index on a table negates the need for a primary key. The PK is normally used to provide a mechanism to allow you to reference a row in another table. This is because the PK is unique, so it uniquely identifies a row.

Indexes can be used in views (DB dependent), but they are not best suited for them.

Please visit http://www.readytogiveup.com/ and do something special today.
Deja View - the feeling that you've seen this post before.

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 
AnswerRe: Subquery returned more than 1 value Pin
jonathan152-Jul-07 6:56
jonathan152-Jul-07 6:56 
GeneralRe: Subquery returned more than 1 value Pin
Sam Heller2-Jul-07 7:00
Sam Heller2-Jul-07 7:00 

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.