Click here to Skip to main content
14,600,316 members
   

Database

 
AnswerRe: Exposing API VS Stored Procedure Pin
Richard MacCutchan31-Aug-16 4:46
mveRichard MacCutchan31-Aug-16 4:46 
Question.mdf file not updated? Pin
kmllev26-Aug-16 16:59
Memberkmllev26-Aug-16 16:59 
GeneralRe: .mdf file not updated? Pin
Richard MacCutchan26-Aug-16 21:07
mveRichard MacCutchan26-Aug-16 21:07 
AnswerRe: .mdf file not updated? Pin
Eddy Vluggen29-Aug-16 4:06
professionalEddy Vluggen29-Aug-16 4:06 
GeneralRe: .mdf file not updated? Pin
kmllev29-Aug-16 5:16
Memberkmllev29-Aug-16 5:16 
QuestionHow to speedup the execution of a query in Sql Server? Pin
Abhijit Mindcraft22-Aug-16 22:52
MemberAbhijit Mindcraft22-Aug-16 22:52 
AnswerRe: How to speedup the execution of a query in Sql Server? Pin
Mycroft Holmes22-Aug-16 23:11
professionalMycroft Holmes22-Aug-16 23:11 
AnswerRe: How to speedup the execution of a query in Sql Server? Pin
David Mujica23-Aug-16 5:35
MemberDavid Mujica23-Aug-16 5:35 
You need to present a bit more detail so that some suggestions can be given.

Generally, are you linking tables together ? How many? How many rows are in each table?

How many rows are being returned in your query?

With the SQL profiler you will be able to tell whether the server is scanning the table or seeking data via an index.

Your question is too vague to get a valuable answer.
GeneralRe: How to speedup the execution of a query in Sql Server? Pin
Abhijit Mindcraft23-Aug-16 19:58
MemberAbhijit Mindcraft23-Aug-16 19:58 
GeneralRe: How to speedup the execution of a query in Sql Server? Pin
Mycroft Holmes23-Aug-16 20:20
professionalMycroft Holmes23-Aug-16 20:20 
AnswerRe: How to speedup the execution of a query in Sql Server? Pin
Eddy Vluggen24-Aug-16 4:09
professionalEddy Vluggen24-Aug-16 4:09 
GeneralRe: How to speedup the execution of a query in Sql Server? Pin
Abhijit Mindcraft24-Aug-16 18:57
MemberAbhijit Mindcraft24-Aug-16 18:57 
QuestionBasic Join Not Working (Copy From LAMP Forum) Pin
Django_Untaken19-Aug-16 2:18
MemberDjango_Untaken19-Aug-16 2:18 
AnswerRe: Basic Join Not Working (Copy From LAMP Forum) Pin
Chris Quinn19-Aug-16 2:34
MemberChris Quinn19-Aug-16 2:34 
Questionpostgresql or mysql? Pin
Member 907660914-Aug-16 20:21
MemberMember 907660914-Aug-16 20:21 
AnswerRe: postgresql or mysql? Pin
Richard MacCutchan14-Aug-16 21:29
mveRichard MacCutchan14-Aug-16 21:29 
AnswerRe: postgresql or mysql? Pin
Tim Carmichael15-Aug-16 10:22
MemberTim Carmichael15-Aug-16 10:22 
AnswerRe: postgresql or mysql? Pin
Eddy Vluggen15-Aug-16 14:22
professionalEddy Vluggen15-Aug-16 14:22 
AnswerRe: postgresql or mysql? Pin
Jörgen Andersson15-Aug-16 21:27
professionalJörgen Andersson15-Aug-16 21:27 
AnswerRe: postgresql or mysql? Pin
jonyj8-Sep-16 10:20
Memberjonyj8-Sep-16 10:20 
QuestionError when passing multiple values Pin
Jassim Rahma12-Aug-16 12:53
MemberJassim Rahma12-Aug-16 12:53 
AnswerRe: Error when passing multiple values Pin
Mycroft Holmes12-Aug-16 14:21
professionalMycroft Holmes12-Aug-16 14:21 
GeneralRe: Error when passing multiple values Pin
Jassim Rahma13-Aug-16 5:32
MemberJassim Rahma13-Aug-16 5:32 
GeneralRe: Error when passing multiple values Pin
Richard MacCutchan13-Aug-16 6:03
mveRichard MacCutchan13-Aug-16 6:03 
GeneralRe: Error when passing multiple values Pin
Jassim Rahma13-Aug-16 7:08
MemberJassim Rahma13-Aug-16 7:08 

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.