Click here to Skip to main content
12,239,973 members (59,609 online)
   

Database

 
AnswerRe: I keep running into xml format issues in various editors ... please advise Pin
Davidduraisamy8-Mar-13 1:54
memberDavidduraisamy8-Mar-13 1:54 
GeneralRe: I keep running into xml format issues in various editors ... please advise Pin
RedDK8-Mar-13 9:31
memberRedDK8-Mar-13 9:31 
Questionhow to unloch table in sql Pin
mehdi.sabet7-Mar-13 8:38
groupmehdi.sabet7-Mar-13 8:38 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 9:01
mvpEddy Vluggen7-Mar-13 9:01 
GeneralRe: how to unloch table in sql Pin
mehdi.sabet7-Mar-13 22:15
groupmehdi.sabet7-Mar-13 22:15 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 23:31
mvpEddy Vluggen7-Mar-13 23:31 
GeneralRe: how to unloch table in sql Pin
mehdi.sabet7-Mar-13 23:51
groupmehdi.sabet7-Mar-13 23:51 
Questiona query by less performnace Pin
mehdi.sabet7-Mar-13 5:00
groupmehdi.sabet7-Mar-13 5: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 9:02
mvpEddy Vluggen7-Mar-13 9:02 
GeneralRe: a query by less performnace Pin
mehdi.sabet7-Mar-13 23:46
groupmehdi.sabet7-Mar-13 23:46 
GeneralRe: a query by less performnace Pin
Eddy Vluggen7-Mar-13 23:49
mvpEddy Vluggen7-Mar-13 23:49 
GeneralRe: a query by less performnace Pin
mehdi.sabet8-Mar-13 0:08
groupmehdi.sabet8-Mar-13 0:08 
AnswerRe: a query by less performnace Pin
Mycroft Holmes7-Mar-13 13:04
memberMycroft Holmes7-Mar-13 13:04 
GeneralRe: a query by less performnace Pin
mehdi.sabet7-Mar-13 23:56
groupmehdi.sabet7-Mar-13 23:56 
QuestionHow to use sql server database into oracle Pin
Arun kumar Gautam7-Mar-13 2:05
memberArun kumar Gautam7-Mar-13 2:05 
AnswerRe: How to use sql server database into oracle Pin
Sandeep Mewara7-Mar-13 2:10
mvpSandeep Mewara7-Mar-13 2:10 
GeneralRe: How to use sql server database into oracle Pin
Davidduraisamy7-Mar-13 2:13
memberDavidduraisamy7-Mar-13 2:13 
GeneralRe: How to use sql server database into oracle Pin
mehdi.sabet7-Mar-13 22:06
groupmehdi.sabet7-Mar-13 22:06 
GeneralRe: How to use sql server database into oracle Pin
Davidduraisamy7-Mar-13 22:30
memberDavidduraisamy7-Mar-13 22:30 
GeneralRe: How to use sql server database into oracle Pin
mehdi.sabet7-Mar-13 22:59
groupmehdi.sabet7-Mar-13 22:59 
QuestionCreate a table for prices Pin
MedZi20106-Mar-13 19:10
memberMedZi20106-Mar-13 19:10 
AnswerRe: Create a table for prices Pin
Member 95016167-Mar-13 1:43
memberMember 95016167-Mar-13 1:43 
GeneralRe: Create a table for prices Pin
Davidduraisamy7-Mar-13 2:10
memberDavidduraisamy7-Mar-13 2:10 
AnswerRe: Create a table for prices Pin
Sandeep Mewara7-Mar-13 2:08
mvpSandeep Mewara7-Mar-13 2:08 
AnswerRe: Create a table for prices Pin
MedZi20107-Mar-13 16:29
memberMedZi20107-Mar-13 16:29 

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.


Advertise | Privacy | Mobile
Web01 | 2.8.160426.1 | Last Updated 27 Apr 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid