Click here to Skip to main content
15,867,835 members
Home / Discussions / Database
   

Database

 
GeneralRe: Help needed on string function Pin
Ambertje24-Mar-15 23:43
Ambertje24-Mar-15 23:43 
GeneralRe: Help needed on string function Pin
Johan Hakkesteegt8-Apr-15 2:36
Johan Hakkesteegt8-Apr-15 2:36 
QuestionVB.NET MYSQL DATATABLE Pin
Pauls Pauls21-Mar-15 4:33
Pauls Pauls21-Mar-15 4:33 
AnswerRe: VB.NET MYSQL DATATABLE Pin
Peter Leow21-Mar-15 4:56
professionalPeter Leow21-Mar-15 4:56 
AnswerRe: VB.NET MYSQL DATATABLE Pin
manchanx21-Mar-15 5:14
professionalmanchanx21-Mar-15 5:14 
GeneralRe: VB.NET MYSQL DATATABLE Pin
Pauls Pauls21-Mar-15 6:16
Pauls Pauls21-Mar-15 6:16 
QuestionOracle, inner join and substr function Pin
Ludwing RS20-Mar-15 9:29
Ludwing RS20-Mar-15 9:29 
AnswerRe: Oracle, inner join and substr function Pin
Eddy Vluggen20-Mar-15 10:21
professionalEddy Vluggen20-Mar-15 10:21 
Ludwing RS wrote:
I have a query and it takes too much time to fetch
How much time would be allowed?

There's no faster alternative to splitting a string, but it does count as a design-mistake. Each attribute in the tupel should be atomic. You should not need to separate the facts from a single field. They should have been two separate columns.

You "could" try to create an view that does the splitting, and making sure that those calculated columns are materialized. It would effectively move the extra processing required to when the view is created, rather then when the data is requested.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

AnswerRe: Oracle, inner join and substr function Pin
Jörgen Andersson20-Mar-15 13:20
professionalJörgen Andersson20-Mar-15 13:20 
GeneralRe: Oracle, inner join and substr function Pin
Ludwing RS23-Mar-15 8:02
Ludwing RS23-Mar-15 8:02 
QuestionSSRS merging main header of two columns into one and then splitting subheadings Pin
indian14316-Mar-15 12:39
indian14316-Mar-15 12:39 
QuestionSSRS Report not allowing to edit name of the field Pin
indian14316-Mar-15 11:44
indian14316-Mar-15 11:44 
AnswerRe: SSRS Report not allowing to edit name of the field Pin
Richard Deeming17-Mar-15 3:42
mveRichard Deeming17-Mar-15 3:42 
GeneralRe: SSRS Report not allowing to edit name of the field Pin
indian14318-Mar-15 12:46
indian14318-Mar-15 12:46 
QuestionHelp with SSAS project Pin
rafael.avaria16-Mar-15 7:10
rafael.avaria16-Mar-15 7:10 
QuestionProblem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 6:38
delgaillo12-Mar-15 6:38 
AnswerRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 14:51
professionalMycroft Holmes12-Mar-15 14:51 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo12-Mar-15 22:12
delgaillo12-Mar-15 22:12 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
Mycroft Holmes12-Mar-15 22:14
professionalMycroft Holmes12-Mar-15 22:14 
GeneralRe: Problem executing backup script in Sql Server 2012 Pin
delgaillo28-Sep-15 0:17
delgaillo28-Sep-15 0:17 
QuestionCreating SQL statements in Access Databases Pin
Member 115083508-Mar-15 14:25
Member 115083508-Mar-15 14:25 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 15:33
professionalRichard Andrew x648-Mar-15 15:33 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 15:42
Member 115083508-Mar-15 15:42 
AnswerRe: Creating SQL statements in Access Databases Pin
Richard Andrew x648-Mar-15 15:48
professionalRichard Andrew x648-Mar-15 15:48 
GeneralRe: Creating SQL statements in Access Databases Pin
Member 115083508-Mar-15 15:59
Member 115083508-Mar-15 15:59 

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.