Click here to Skip to main content
15,357,682 members
Home / Discussions / Database
   

Database

 
GeneralRe: get all parent tables name with child from sql 2005 Pin
Mycroft Holmes23-Aug-09 21:19
professionalMycroft Holmes23-Aug-09 21:19 
GeneralRe: get all parent tables name with child from sql 2005 Pin
Abdul Rahman Hamidy24-Aug-09 1:57
MemberAbdul Rahman Hamidy24-Aug-09 1:57 
QuestionStoring data which in the form of a list to database. Pin
udaykatakam21-Aug-09 8:04
Memberudaykatakam21-Aug-09 8:04 
AnswerRe: Storing data which in the form of a list to database. Pin
Mycroft Holmes21-Aug-09 17:18
professionalMycroft Holmes21-Aug-09 17:18 
GeneralRe: Storing data which in the form of a list to database. Pin
udaykatakam23-Aug-09 21:32
Memberudaykatakam23-Aug-09 21:32 
GeneralRe: Storing data which in the form of a list to database. Pin
Mycroft Holmes23-Aug-09 21:48
professionalMycroft Holmes23-Aug-09 21:48 
GeneralRe: Storing data which in the form of a list to database. Pin
udaykatakam24-Aug-09 11:29
Memberudaykatakam24-Aug-09 11:29 
QuestionAbout the SQL Execution Plan Pin
mctramp16820-Aug-09 22:09
Membermctramp16820-Aug-09 22:09 
1、How to know which SQL statement runs faster than the other SQL statement by contrasting the being displayed execution plan?
2、Could you please tell me the meaning of I/O Cost、CPU Cost、Subtree Cost and Cost? and what is the measuring unit of these
costs? and if there is a mathematical expression among the cost,say Cost=I/O Cost+Cpu Cost+subtree cost?
3、Is it possible to compute the accurate time of one SQL statements execution costed by execution plan?
AnswerRe: About the SQL Execution Plan Pin
Ashfield20-Aug-09 23:19
MemberAshfield20-Aug-09 23:19 
AnswerRe: About the SQL Execution Plan Pin
Mycroft Holmes21-Aug-09 0:38
professionalMycroft Holmes21-Aug-09 0:38 
GeneralRe: About the SQL Execution Plan Pin
David Mujica21-Aug-09 2:54
MemberDavid Mujica21-Aug-09 2:54 
QuestionSQL:Find one primary key of each duplicate records Pin
xodeblack20-Aug-09 19:42
Memberxodeblack20-Aug-09 19:42 
AnswerRe: SQL:Find one primary key of each duplicate records Pin
Ashfield20-Aug-09 21:01
MemberAshfield20-Aug-09 21:01 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
xodeblack20-Aug-09 21:25
Memberxodeblack20-Aug-09 21:25 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Ashfield21-Aug-09 1:21
MemberAshfield21-Aug-09 1:21 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
xodeblack21-Aug-09 1:28
Memberxodeblack21-Aug-09 1:28 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Ashfield21-Aug-09 4:20
MemberAshfield21-Aug-09 4:20 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Coding C#20-Aug-09 22:25
MemberCoding C#20-Aug-09 22:25 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
David Skelly20-Aug-09 22:32
MemberDavid Skelly20-Aug-09 22:32 
GeneralRe: SQL:Find one primary key of each duplicate records Pin
Ashfield21-Aug-09 1:19
MemberAshfield21-Aug-09 1:19 
QuestionLIKE Predicate Pin
TheIdleProgrammer20-Aug-09 3:50
MemberTheIdleProgrammer20-Aug-09 3:50 
AnswerRe: LIKE Predicate Pin
Mycroft Holmes20-Aug-09 4:17
professionalMycroft Holmes20-Aug-09 4:17 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 4:28
MemberTheIdleProgrammer20-Aug-09 4:28 
GeneralRe: LIKE Predicate Pin
Mycroft Holmes20-Aug-09 13:15
professionalMycroft Holmes20-Aug-09 13:15 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 22:10
MemberTheIdleProgrammer20-Aug-09 22:10 

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.