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

Database

 
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 
GeneralRe: SQL Advice needed Pin
Graham Bradshaw23-Jul-08 10:26
Graham Bradshaw23-Jul-08 10:26 
StevenWalsh wrote:
its flatlined at 100% CPU usage all day


What process is usingthe CPU?
What is the physical disk subsystem? IDE drives can be very processor intensive, especially when writing.

StevenWalsh wrote:
I've done all the SQL optimizations i can think of (indexing, and what not)


What indices do you have? Adding indices will only help querying performance - it will slow down inserts, updates and deletes.

Are you in auto-commit mode, with an implicit commit after every insert, or do you perform number of inserts in a transaction and then commit? Auto-commit hurts performance since the database engine updates the indices for every insert.

As a suggestion, if you are not querying the data during the day, you could consider writing it to a formatted text file, and use SQL Servers bulk copy to load it once per day.
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 
QuestionAttaching database Pin
hadad22-Jul-08 22:37
hadad22-Jul-08 22: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.