Click here to Skip to main content
14,302,838 members
   

Database

 
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
mhd.sbt7-Mar-13 7:38
groupmhd.sbt7-Mar-13 7:38 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 8:01
mveEddy Vluggen7-Mar-13 8:01 
GeneralRe: how to unloch table in sql Pin
mhd.sbt7-Mar-13 21:15
groupmhd.sbt7-Mar-13 21:15 
AnswerRe: how to unloch table in sql Pin
Eddy Vluggen7-Mar-13 22:31
mveEddy Vluggen7-Mar-13 22:31 
GeneralRe: how to unloch table in sql Pin
mhd.sbt7-Mar-13 22:51
groupmhd.sbt7-Mar-13 22:51 
Questiona query by less performnace Pin
mhd.sbt7-Mar-13 4:00
groupmhd.sbt7-Mar-13 4:00 
AnswerRe: a query by less performnace Pin
Eddy Vluggen7-Mar-13 8:02
mveEddy Vluggen7-Mar-13 8:02 
mehdi.sabet wrote:
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).

..caused by the ROW_NUMBER function. Do you need it? Is it "just" a way of numbering the records? If yes, select into a temp-table and add the ROW_NUMBER there.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: a query by less performnace Pin
mhd.sbt7-Mar-13 22:46
groupmhd.sbt7-Mar-13 22:46 
GeneralRe: a query by less performnace Pin
Eddy Vluggen7-Mar-13 22:49
mveEddy Vluggen7-Mar-13 22:49 
GeneralRe: a query by less performnace Pin
mhd.sbt7-Mar-13 23:08
groupmhd.sbt7-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
mhd.sbt7-Mar-13 22:56
groupmhd.sbt7-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
mentorSandeep 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
mhd.sbt7-Mar-13 21:06
groupmhd.sbt7-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
mhd.sbt7-Mar-13 21:59
groupmhd.sbt7-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
Anish_Chakraborty7-Mar-13 0:43
memberAnish_Chakraborty7-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
mentorSandeep 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 

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.