Click here to Skip to main content
15,843,623 members
Home / Discussions / Database
   

Database

 
GeneralRe: Nested Aggregate Function Pin
Wendelius23-Jul-08 12:53
mentorWendelius23-Jul-08 12:53 
AnswerRe: Nested Aggregate Function Pin
Wendelius23-Jul-08 12:35
mentorWendelius23-Jul-08 12:35 
GeneralRe: Nested Aggregate Function Pin
Lash2023-Jul-08 13:23
Lash2023-Jul-08 13:23 
GeneralSQL Advice needed [modified] Pin
StevenWalsh23-Jul-08 9:22
StevenWalsh23-Jul-08 9:22 
GeneralRe: SQL Advice needed Pin
PIEBALDconsult23-Jul-08 9:51
mvePIEBALDconsult23-Jul-08 9:51 
GeneralRe: SQL Advice needed Pin
Ennis Ray Lynch, Jr.23-Jul-08 9:54
Ennis Ray Lynch, Jr.23-Jul-08 9:54 
GeneralRe: SQL Advice needed Pin
StevenWalsh23-Jul-08 10:54
StevenWalsh23-Jul-08 10:54 
GeneralRe: SQL Advice needed [modified] Pin
Pete O'Hanlon23-Jul-08 9:59
subeditorPete O'Hanlon23-Jul-08 9:59 
With a bit of reengineering, I'd consider moving the load process out into a message queue and then load the data into a separate database on a separate server. Then, periodically do a bulk insert from this table.

Deja View - the feeling that you've seen this post before.

My blog | My articles



modified on Wednesday, July 23, 2008 3:49 PM

GeneralRe: SQL Advice needed Pin
Graham Bradshaw23-Jul-08 10:26
Graham Bradshaw23-Jul-08 10:26 
GeneralRe: SQL Advice needed Pin
Daniel Turini23-Jul-08 10:35
Daniel Turini23-Jul-08 10:35 
GeneralRe: SQL Advice needed Pin
Graham Bradshaw23-Jul-08 10:41
Graham Bradshaw23-Jul-08 10:41 
GeneralRe: SQL Advice needed Pin
StevenWalsh23-Jul-08 10:49
StevenWalsh23-Jul-08 10:49 
GeneralRe: SQL Advice needed Pin
Pete O'Hanlon23-Jul-08 10:52
subeditorPete O'Hanlon23-Jul-08 10:52 
GeneralRe: SQL Advice needed Pin
GuyThiebaut23-Jul-08 11:28
professionalGuyThiebaut23-Jul-08 11:28 
GeneralRe: SQL Advice needed Pin
SomeGuyThatIsMe24-Jul-08 3:41
SomeGuyThatIsMe24-Jul-08 3:41 
GeneralRe: SQL Advice needed Pin
StevenWalsh24-Jul-08 5:40
StevenWalsh24-Jul-08 5:40 
GeneralRe: SQL Advice needed Pin
SomeGuyThatIsMe24-Jul-08 5:47
SomeGuyThatIsMe24-Jul-08 5:47 
QuestionCreating Reports using DataSet Pin
Reality Strikes23-Jul-08 6:19
Reality Strikes23-Jul-08 6:19 
AnswerRe: Creating Reports using DataSet Pin
Wendelius23-Jul-08 7:20
mentorWendelius23-Jul-08 7:20 
GeneralRe: Creating Reports using DataSet Pin
Verghese25-Jul-08 5:57
Verghese25-Jul-08 5:57 
GeneralRe: Creating Reports using DataSet Pin
Wendelius25-Jul-08 10:37
mentorWendelius25-Jul-08 10:37 
QuestionSELECT command Pin
Reality Strikes23-Jul-08 5:33
Reality Strikes23-Jul-08 5:33 
AnswerRe: SELECT command Pin
Harvey Saayman23-Jul-08 5:46
Harvey Saayman23-Jul-08 5:46 
GeneralRe: SELECT command Pin
Reality Strikes23-Jul-08 6:00
Reality Strikes23-Jul-08 6:00 
GeneralRe: SELECT command Pin
Harvey Saayman23-Jul-08 6:57
Harvey Saayman23-Jul-08 6:57 

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.