Click here to Skip to main content
11,716,249 members (90,666 online)
   

Database

 
Questiondb_accessadmin? Pin
ThePotty17-Mar-13 23:57
memberThePotty17-Mar-13 23:57 
AnswerRe: db_accessadmin? Pin
JammoD878-Mar-13 1:21
memberJammoD878-Mar-13 1:21 
GeneralRe: db_accessadmin? Pin
ThePotty18-Mar-13 1:53
memberThePotty18-Mar-13 1:53 
QuestionI keep running into xml format issues in various editors ... please advise Pin
RedDK7-Mar-13 11:13
memberRedDK7-Mar-13 11:13 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
RedDK7-Mar-13 12:13
memberRedDK7-Mar-13 12:13 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
Davidduraisamy7-Mar-13 19:45
memberDavidduraisamy7-Mar-13 19:45 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
Davidduraisamy8-Mar-13 0:54
memberDavidduraisamy8-Mar-13 0:54 
GeneralRe: I keep running into xml format issues in various editors ... please advise Pin
RedDK8-Mar-13 8:31
memberRedDK8-Mar-13 8:31 
Questionhow to unloch table in sql Pin
mehdi.sabet7-Mar-13 7:38
groupmehdi.sabet7-Mar-13 7:38 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 8:01
mvpEddy Vluggen7-Mar-13 8:01 
GeneralRe: how to unloch table in sql Pin
mehdi.sabet7-Mar-13 21:15
groupmehdi.sabet7-Mar-13 21:15 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 22:31
mvpEddy Vluggen7-Mar-13 22:31 
GeneralRe: how to unloch table in sql Pin
mehdi.sabet7-Mar-13 22:51
groupmehdi.sabet7-Mar-13 22:51 
Questiona query by less performnace Pin
mehdi.sabet7-Mar-13 4:00
groupmehdi.sabet7-Mar-13 4:00 
hi to all
im face with low performance by below query in sql server 2008 any one can help me.
my query is goon work when top has larg number but when top has less row (for example top 19) this query has low performance for table loaninstallment with amount of records(10000000 R).
any one can help me
thanks for any help
my code:
select top 19 * from(select ROW_NUMBER()over (order by ID ) as rowNumber,* from BML.LoanInstallment where total_amount like '%80%') tbl

AnswerRe: a query by less performnace Pin
Eddy Vluggen7-Mar-13 8:02
mvpEddy Vluggen7-Mar-13 8:02 
GeneralRe: a query by less performnace Pin
mehdi.sabet7-Mar-13 22:46
groupmehdi.sabet7-Mar-13 22:46 
GeneralRe: a query by less performnace Pin
Eddy Vluggen7-Mar-13 22:49
mvpEddy Vluggen7-Mar-13 22:49 
GeneralRe: a query by less performnace Pin
mehdi.sabet7-Mar-13 23:08
groupmehdi.sabet7-Mar-13 23:08 
AnswerRe: a query by less performnace Pin
Mycroft Holmes7-Mar-13 12:04
memberMycroft Holmes7-Mar-13 12:04 
GeneralRe: a query by less performnace Pin
mehdi.sabet7-Mar-13 22:56
groupmehdi.sabet7-Mar-13 22:56 
QuestionHow to use sql server database into oracle Pin
Arun kumar Gautam7-Mar-13 1:05
memberArun kumar Gautam7-Mar-13 1:05 
AnswerRe: How to use sql server database into oracle Pin
Sandeep Mewara7-Mar-13 1:10
mvpSandeep Mewara7-Mar-13 1:10 
GeneralRe: How to use sql server database into oracle Pin
Davidduraisamy7-Mar-13 1:13
memberDavidduraisamy7-Mar-13 1:13 
GeneralRe: How to use sql server database into oracle Pin
mehdi.sabet7-Mar-13 21:06
groupmehdi.sabet7-Mar-13 21:06 
GeneralRe: How to use sql server database into oracle Pin
Davidduraisamy7-Mar-13 21:30
memberDavidduraisamy7-Mar-13 21:30 
GeneralRe: How to use sql server database into oracle Pin
mehdi.sabet7-Mar-13 21:59
groupmehdi.sabet7-Mar-13 21:59 
QuestionCreate a table for prices Pin
MedZi20106-Mar-13 18:10
memberMedZi20106-Mar-13 18:10 
AnswerRe: Create a table for prices Pin
Member 95016167-Mar-13 0:43
memberMember 95016167-Mar-13 0:43 
GeneralRe: Create a table for prices Pin
Davidduraisamy7-Mar-13 1:10
memberDavidduraisamy7-Mar-13 1:10 
AnswerRe: Create a table for prices Pin
Sandeep Mewara7-Mar-13 1:08
mvpSandeep Mewara7-Mar-13 1:08 
AnswerRe: Create a table for prices Pin
MedZi20107-Mar-13 15:29
memberMedZi20107-Mar-13 15:29 
Questionretrieving 3 working days Pin
Member 87018135-Mar-13 7:53
memberMember 87018135-Mar-13 7:53 
AnswerRe: retrieving 3 working days Pin
Mycroft Holmes5-Mar-13 12:01
memberMycroft Holmes5-Mar-13 12:01 
Questionchecking whether today's date is public holiday Pin
Member 87018134-Mar-13 7:08
memberMember 87018134-Mar-13 7:08 
AnswerRe: checking whether today's date is public holiday Pin
David Mujica4-Mar-13 8:20
memberDavid Mujica4-Mar-13 8:20 
AnswerRe: checking whether today's date is public holiday Pin
Mycroft Holmes4-Mar-13 11:43
memberMycroft Holmes4-Mar-13 11:43 
GeneralRe: checking whether today's date is public holiday Pin
Member 87018134-Mar-13 21:28
memberMember 87018134-Mar-13 21:28 
GeneralRe: checking whether today's date is public holiday Pin
Member 87018134-Mar-13 21:41
memberMember 87018134-Mar-13 21:41 
QuestionActivate reminder for event to send email notification 3 days before event Pin
Member 87018133-Mar-13 6:01
memberMember 87018133-Mar-13 6:01 
AnswerRe: Activate reminder for event to send email notification 3 days before event Pin
Mycroft Holmes3-Mar-13 11:59
memberMycroft Holmes3-Mar-13 11:59 
AnswerRe: Activate reminder for event to send email notification 3 days before event Pin
Sandeep Mewara3-Mar-13 18:45
mvpSandeep Mewara3-Mar-13 18:45 
AnswerRe: Activate reminder for event to send email notification 3 days before event Pin
Davidduraisamy4-Mar-13 23:52
memberDavidduraisamy4-Mar-13 23:52 
Questionpeak hours query Pin
Jassim Rahma2-Mar-13 23:38
memberJassim Rahma2-Mar-13 23:38 
AnswerRe: peak hours query Pin
Mycroft Holmes3-Mar-13 12:02
memberMycroft Holmes3-Mar-13 12:02 
AnswerRe: peak hours query Pin
Bernhard Hiller3-Mar-13 20:39
memberBernhard Hiller3-Mar-13 20:39 
AnswerRe: peak hours query Pin
S Douglas4-Mar-13 9:49
memberS Douglas4-Mar-13 9:49 
QuestionProblem closing patient file! Pin
Jassim Rahma2-Mar-13 21:34
memberJassim Rahma2-Mar-13 21:34 
AnswerRe: Problem closing patient file! Pin
Edo Tzumer2-Mar-13 21:50
memberEdo Tzumer2-Mar-13 21:50 
GeneralRe: Problem closing patient file! Pin
Jassim Rahma2-Mar-13 22:24
memberJassim Rahma2-Mar-13 22:24 
GeneralRe: Problem closing patient file! Pin
Edo Tzumer2-Mar-13 22:29
memberEdo Tzumer2-Mar-13 22:29 

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

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


Advertise | Privacy | Mobile
Web02 | 2.8.150901.1 | Last Updated 3 Sep 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid