Click here to Skip to main content
15,879,683 members
Home / Discussions / Database
   

Database

 
AnswerRe: "loop" this for me please Pin
BadhShah24-Jul-08 2:45
BadhShah24-Jul-08 2:45 
GeneralRe: "loop" this for me please Pin
nelsonpaixao24-Jul-08 12:10
nelsonpaixao24-Jul-08 12:10 
QuestionNested Aggregate Function Pin
Lash2023-Jul-08 9:56
Lash2023-Jul-08 9:56 
AnswerRe: Nested Aggregate Function Pin
TheFM23423-Jul-08 11:28
TheFM23423-Jul-08 11:28 
GeneralRe: Nested Aggregate Function Pin
Wendelius23-Jul-08 11:53
mentorWendelius23-Jul-08 11:53 
AnswerRe: Nested Aggregate Function Pin
Wendelius23-Jul-08 11:35
mentorWendelius23-Jul-08 11:35 
GeneralRe: Nested Aggregate Function Pin
Lash2023-Jul-08 12:23
Lash2023-Jul-08 12:23 
GeneralSQL Advice needed [modified] Pin
StevenWalsh23-Jul-08 8:22
StevenWalsh23-Jul-08 8:22 
This isn't a programming question... so thats why i'm here Smile | :)
I'm working on a system thats working with some stock market data (this is a personal project at home) The system is collecting about 7 million records a week, and its really starting to slow down. I've done all the SQL optimizations i can think of (indexing, and what not) but i'm running into a road block with hardware i think... during the day when its downloading new quotes its flatlined at 100% CPU usage all day, and i'm seeing an increase of errors due to timeouts (when attempting to submit more data to sql). Currently the database engine is running on 1 dell poweredge 2550, i have 4 other servers with similar hardware (and 5 more that aren't really servers) so i'm looking for a way to distribute the load amoung the other servers. I've started to think about clustering, but i believe thats only for error tolerance (incase the server goes down) anyone have anyother suggestions?

modified on Wednesday, July 23, 2008 6:11 PM

GeneralRe: SQL Advice needed Pin
PIEBALDconsult23-Jul-08 8:51
mvePIEBALDconsult23-Jul-08 8:51 
GeneralRe: SQL Advice needed Pin
Ennis Ray Lynch, Jr.23-Jul-08 8:54
Ennis Ray Lynch, Jr.23-Jul-08 8:54 
GeneralRe: SQL Advice needed Pin
StevenWalsh23-Jul-08 9:54
StevenWalsh23-Jul-08 9:54 
GeneralRe: SQL Advice needed [modified] Pin
Pete O'Hanlon23-Jul-08 8:59
mvePete O'Hanlon23-Jul-08 8:59 
GeneralRe: SQL Advice needed Pin
Graham Bradshaw23-Jul-08 9:26
Graham Bradshaw23-Jul-08 9:26 
GeneralRe: SQL Advice needed Pin
Daniel Turini23-Jul-08 9:35
Daniel Turini23-Jul-08 9:35 
GeneralRe: SQL Advice needed Pin
Graham Bradshaw23-Jul-08 9:41
Graham Bradshaw23-Jul-08 9:41 
GeneralRe: SQL Advice needed Pin
StevenWalsh23-Jul-08 9:49
StevenWalsh23-Jul-08 9:49 
GeneralRe: SQL Advice needed Pin
Pete O'Hanlon23-Jul-08 9:52
mvePete O'Hanlon23-Jul-08 9:52 
GeneralRe: SQL Advice needed Pin
GuyThiebaut23-Jul-08 10:28
professionalGuyThiebaut23-Jul-08 10:28 
GeneralRe: SQL Advice needed Pin
SomeGuyThatIsMe24-Jul-08 2:41
SomeGuyThatIsMe24-Jul-08 2:41 
GeneralRe: SQL Advice needed Pin
StevenWalsh24-Jul-08 4:40
StevenWalsh24-Jul-08 4:40 
GeneralRe: SQL Advice needed Pin
SomeGuyThatIsMe24-Jul-08 4:47
SomeGuyThatIsMe24-Jul-08 4:47 
QuestionCreating Reports using DataSet Pin
Reality Strikes23-Jul-08 5:19
Reality Strikes23-Jul-08 5:19 
AnswerRe: Creating Reports using DataSet Pin
Wendelius23-Jul-08 6:20
mentorWendelius23-Jul-08 6:20 
GeneralRe: Creating Reports using DataSet Pin
Verghese25-Jul-08 4:57
Verghese25-Jul-08 4:57 
GeneralRe: Creating Reports using DataSet Pin
Wendelius25-Jul-08 9:37
mentorWendelius25-Jul-08 9:37 

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.