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

Database

 
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 
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 
I agree. I typically use the execution plan to make sure I can reduce the number of I/O's; no full table scans ... It has been my experience that if you reduce (or limit) the I/O's your application will respond quickly.

Regarding, timing of SQL: Why don't you build your own timer logic and try various SQL statements out? Keep it simple, something like this:

Begin timer1
Execute SQL1
End timer1

Begin timer2
Execute SQL2
End timer2

Now check which timer is the smallest. You will have to collect these statistics multiple times to ensure that you are not getting skewed results because the data happens to be in cache.
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 
GeneralRe: LIKE Predicate Pin
Mycroft Holmes21-Aug-09 0:33
professionalMycroft Holmes21-Aug-09 0:33 
GeneralRe: LIKE Predicate Pin
David Skelly20-Aug-09 22:53
MemberDavid Skelly20-Aug-09 22:53 
GeneralRe: LIKE Predicate Pin
TheIdleProgrammer20-Aug-09 23:07
MemberTheIdleProgrammer20-Aug-09 23:07 

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.