Click here to Skip to main content
       

Database

 
Questiondb_accessadmin? PinmemberThePotty18-Mar-13 0:57 
AnswerRe: db_accessadmin? PinmemberJammoD878-Mar-13 2:21 
GeneralRe: db_accessadmin? PinmemberThePotty18-Mar-13 2:53 
QuestionI keep running into xml format issues in various editors ... please advise PinmemberRedDK7-Mar-13 12:13 
AnswerRe: I keep running into xml format issues in various editors ... please advise PinmemberRedDK7-Mar-13 13:13 
AnswerRe: I keep running into xml format issues in various editors ... please advise PinmemberDavidduraisamy7-Mar-13 20:45 
AnswerRe: I keep running into xml format issues in various editors ... please advise PinmemberDavidduraisamy8-Mar-13 1:54 
GeneralRe: I keep running into xml format issues in various editors ... please advise PinmemberRedDK8-Mar-13 9:31 
Questionhow to unloch table in sql Pingroupmehdi.sabet7-Mar-13 8:38 
AnswerRe: how to unloch table in sql PinmvpEddy Vluggen7-Mar-13 9:01 
GeneralRe: how to unloch table in sql Pingroupmehdi.sabet7-Mar-13 22:15 
AnswerRe: how to unloch table in sql PinmvpEddy Vluggen7-Mar-13 23:31 
GeneralRe: how to unloch table in sql Pingroupmehdi.sabet7-Mar-13 23:51 
Questiona query by less performnace Pingroupmehdi.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 PinmvpEddy Vluggen7-Mar-13 9:02 
GeneralRe: a query by less performnace Pingroupmehdi.sabet7-Mar-13 23:46 
GeneralRe: a query by less performnace PinmvpEddy Vluggen7-Mar-13 23:49 
GeneralRe: a query by less performnace Pingroupmehdi.sabet8-Mar-13 0:08 
AnswerRe: a query by less performnace PinmemberMycroft Holmes7-Mar-13 13:04 
GeneralRe: a query by less performnace Pingroupmehdi.sabet7-Mar-13 23:56 
QuestionHow to use sql server database into oracle PinmemberArun kumar Gautam7-Mar-13 2:05 
AnswerRe: How to use sql server database into oracle PinmvpSandeep Mewara7-Mar-13 2:10 
GeneralRe: How to use sql server database into oracle PinmemberDavidduraisamy7-Mar-13 2:13 
GeneralRe: How to use sql server database into oracle Pingroupmehdi.sabet7-Mar-13 22:06 
GeneralRe: How to use sql server database into oracle PinmemberDavidduraisamy7-Mar-13 22:30 
GeneralRe: How to use sql server database into oracle Pingroupmehdi.sabet7-Mar-13 22:59 
QuestionCreate a table for prices PinmemberMedZi20106-Mar-13 19:10 
AnswerRe: Create a table for prices PinmemberMember 95016167-Mar-13 1:43 
GeneralRe: Create a table for prices PinmemberDavidduraisamy7-Mar-13 2:10 
AnswerRe: Create a table for prices PinmvpSandeep Mewara7-Mar-13 2:08 
AnswerRe: Create a table for prices PinmemberMedZi20107-Mar-13 16:29 
Questionretrieving 3 working days PinmemberMember 87018135-Mar-13 8:53 
AnswerRe: retrieving 3 working days PinmemberMycroft Holmes5-Mar-13 13:01 
Questionchecking whether today's date is public holiday PinmemberMember 87018134-Mar-13 8:08 
AnswerRe: checking whether today's date is public holiday PinmemberDavid Mujica4-Mar-13 9:20 
AnswerRe: checking whether today's date is public holiday PinmemberMycroft Holmes4-Mar-13 12:43 
GeneralRe: checking whether today's date is public holiday PinmemberMember 87018134-Mar-13 22:28 
GeneralRe: checking whether today's date is public holiday PinmemberMember 87018134-Mar-13 22:41 
QuestionActivate reminder for event to send email notification 3 days before event PinmemberMember 87018133-Mar-13 7:01 
AnswerRe: Activate reminder for event to send email notification 3 days before event PinmemberMycroft Holmes3-Mar-13 12:59 
AnswerRe: Activate reminder for event to send email notification 3 days before event PinmvpSandeep Mewara3-Mar-13 19:45 
AnswerRe: Activate reminder for event to send email notification 3 days before event PinmemberDavidduraisamy5-Mar-13 0:52 
Questionpeak hours query PinmemberJassim Rahma3-Mar-13 0:38 
AnswerRe: peak hours query PinmemberMycroft Holmes3-Mar-13 13:02 
AnswerRe: peak hours query PinmemberBernhard Hiller3-Mar-13 21:39 
AnswerRe: peak hours query PinmemberS Douglas4-Mar-13 10:49 
QuestionProblem closing patient file! PinmemberJassim Rahma2-Mar-13 22:34 
AnswerRe: Problem closing patient file! PinmemberEdo Tzumer2-Mar-13 22:50 
GeneralRe: Problem closing patient file! PinmemberJassim Rahma2-Mar-13 23:24 
GeneralRe: Problem closing patient file! PinmemberEdo Tzumer2-Mar-13 23: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
Web01 | 2.8.1411023.1 | Last Updated 27 Nov 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid