Click here to Skip to main content
15,917,005 members
Home / Discussions / Database
   

Database

 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
Eddy Vluggen14-Jul-14 5:27
professionalEddy Vluggen14-Jul-14 5:27 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
PIEBALDconsult14-Jul-14 5:29
mvePIEBALDconsult14-Jul-14 5:29 
QuestionRe: OVER (PARTITION BY ORDER BY ) Pin
Eddy Vluggen14-Jul-14 7:47
professionalEddy Vluggen14-Jul-14 7:47 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
Jörgen Andersson14-Jul-14 8:33
professionalJörgen Andersson14-Jul-14 8:33 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Mycroft Holmes14-Jul-14 12:54
professionalMycroft Holmes14-Jul-14 12:54 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Jörgen Andersson14-Jul-14 22:20
professionalJörgen Andersson14-Jul-14 22:20 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 22:12
Ambertje14-Jul-14 22:12 
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
jschell14-Jul-14 10:07
jschell14-Jul-14 10:07 
Ambertje wrote:
I want to make a dayset so that we only read one single day into the DB on top of the existing data and not the whole year.


I don't see what that has to do with partitions - the database of course wouldn't have anything to do with reading files.

Ambertje wrote:
and takes a long time to process.


Someone should optimize that process. I wouldn't be surprised if that means moving it out of SSIS but maybe it can be sped up as is.

Normally one profiles a process by actually timing the various parts and then using that data to determine where things can be made faster.

Although your description might suggest that every day you read the previous years data. If so one obvious optimization there would be to some producing a file that has a years worth of data. How one does that depends on the data.
AnswerRe: OVER (PARTITION BY ORDER BY ) Pin
GuyThiebaut14-Jul-14 21:33
professionalGuyThiebaut14-Jul-14 21:33 
GeneralRe: OVER (PARTITION BY ORDER BY ) Pin
Ambertje14-Jul-14 22:13
Ambertje14-Jul-14 22:13 
QuestionError: Can't delete row or update row in SQL Server ? Pin
taibc11-Jul-14 18:29
taibc11-Jul-14 18:29 
AnswerRe: Error: Can't delete row or update row in SQL Server ? Pin
Mycroft Holmes11-Jul-14 23:32
professionalMycroft Holmes11-Jul-14 23:32 
GeneralRe: Error: Can't delete row or update row in SQL Server ? Pin
taibc13-Jul-14 20:36
taibc13-Jul-14 20:36 
GeneralRe: Error: Can't delete row or update row in SQL Server ? Pin
Mycroft Holmes13-Jul-14 21:06
professionalMycroft Holmes13-Jul-14 21:06 
AnswerRe: Error: Can't delete row or update row in SQL Server ? Pin
ZurdoDev14-Jul-14 10:14
professionalZurdoDev14-Jul-14 10:14 
QuestionJOIN vs. WHERE Pin
Klaus-Werner Konrad11-Jul-14 9:22
Klaus-Werner Konrad11-Jul-14 9:22 
AnswerRe: JOIN vs. WHERE Pin
Mycroft Holmes11-Jul-14 14:24
professionalMycroft Holmes11-Jul-14 14:24 
GeneralRe: JOIN vs. WHERE Pin
Klaus-Werner Konrad12-Jul-14 9:08
Klaus-Werner Konrad12-Jul-14 9:08 
GeneralRe: JOIN vs. WHERE Pin
Mycroft Holmes12-Jul-14 14:13
professionalMycroft Holmes12-Jul-14 14:13 
GeneralRe: JOIN vs. WHERE Pin
Klaus-Werner Konrad13-Jul-14 0:08
Klaus-Werner Konrad13-Jul-14 0:08 
AnswerRe: JOIN vs. WHERE Pin
data modeling guy11-Jul-14 19:53
data modeling guy11-Jul-14 19:53 
GeneralRe: JOIN vs. WHERE Pin
Mycroft Holmes11-Jul-14 23:29
professionalMycroft Holmes11-Jul-14 23:29 
GeneralRe: JOIN vs. WHERE Pin
Jörgen Andersson12-Jul-14 9:42
professionalJörgen Andersson12-Jul-14 9:42 
AnswerRe: JOIN vs. WHERE Pin
Jörgen Andersson12-Jul-14 10:25
professionalJörgen Andersson12-Jul-14 10:25 
GeneralRe: JOIN vs. WHERE Pin
Mycroft Holmes12-Jul-14 14:22
professionalMycroft Holmes12-Jul-14 14:22 

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.