Click here to Skip to main content
       

Database

 
AnswerRe: Problem with MySQL stored procedure PinmemberEddy Vluggen8-Oct-12 1:51 
AnswerRe: Problem with MySQL stored procedure PinmemberBernhard Hiller7-Oct-12 23:26 
GeneralRe: Problem with MySQL stored procedure Pinmemberjrahma8-Oct-12 0:31 
AnswerRe: Problem with MySQL stored procedure PinmemberShameel8-Oct-12 2:56 
GeneralRe: Problem with MySQL stored procedure Pinmemberjrahma8-Oct-12 7:54 
GeneralRe: Problem with MySQL stored procedure Pinmemberjrahma8-Oct-12 8:11 
Questionterminating SqlConnection.Open() call while connecting PinmemberDan_K4-Oct-12 8:43 
AnswerRe: terminating SqlConnection.Open() call while connecting [modified] PinmemberShameel4-Oct-12 9:46 
AnswerRe: terminating SqlConnection.Open() call while connecting PinmemberEddy Vluggen4-Oct-12 10:10 
GeneralRe: terminating SqlConnection.Open() call while connecting PinmemberDan_K5-Oct-12 5:37 
GeneralRe: terminating SqlConnection.Open() call while connecting PinmemberEddy Vluggen5-Oct-12 5:57 
QuestionSQL 2000 to 2008R2 Query Performance Pinmembercjb1104-Oct-12 6:13 
AnswerRe: SQL 2000 to 2008R2 Query Performance PinmemberShameel4-Oct-12 10:01 
GeneralRe: SQL 2000 to 2008R2 Query Performance Pinmembercjb1104-Oct-12 23:30 
Rebuilding indexes didn't seem to help.
 
But updating all the stats did, the sample I was looking at now processes in 6s rather than 9h.
 
My concern now is I have Auto Update Stats On, and Update Stats Async, and the way the system works is it that each stage wipes the working tables before processing. So the stats would be invalidated every run.
 
Now we obviously could go through and do manual stat updates, but should we need to? Given we didn't for 2000.
 
Also I think that SQL is memory starved, would this be preventing it from also auto-updating stats?
AnswerExecution plan PinmemberDavid Mujica4-Oct-12 11:25 
GeneralRe: Execution plan Pinmembercjb1104-Oct-12 21:58 
GeneralRe: Execution plan PinmemberDavid Mujica8-Oct-12 9:54 
GeneralRe: Execution plan Pinmembercjb1109-Oct-12 0:41 
GeneralRe: Execution plan PinmemberDavid Mujica9-Oct-12 4:12 
GeneralRe: Execution plan Pinmembercjb1109-Oct-12 5:34 
GeneralHigh CPU PinmemberDavid Mujica9-Oct-12 10:13 
GeneralRe: High CPU Pinmembercjb11010-Oct-12 22:30 
GeneralRe: High CPU Pinmembercjb11011-Oct-12 0:15 
QuestionMySQL Server timestamp changed! Pinmemberjrahma2-Oct-12 22:53 
AnswerRe: MySQL Server timestamp changed! PinmemberShameel3-Oct-12 5:05 
QuestionConnection String for Ms access 2010 to Windows 7 64 Bit PinmemberSatyam Tripathi2-Oct-12 22:33 
AnswerRe: Connection String for Ms access 2010 to Windows 7 64 Bit PinmvpRichard MacCutchan2-Oct-12 23:00 
QuestionBackup/Recover of row data in a multi-Company database PinmemberDeDawg2-Oct-12 11:35 
AnswerRe: Backup/Recover of row data in a multi-Company database PinmvpMika Wendelius2-Oct-12 12:17 
GeneralRe: Backup/Recover of row data in a multi-Company database PinmemberDeDawg2-Oct-12 12:22 
GeneralRe: Backup/Recover of row data in a multi-Company database PinmvpMika Wendelius2-Oct-12 19:22 
AnswerRe: Backup/Recover of row data in a multi-Company database PinmemberMycroft Holmes3-Oct-12 8:39 
GeneralRe: Backup/Recover of row data in a multi-Company database PinmemberDeDawg3-Oct-12 8:43 
GeneralRe: Backup/Recover of row data in a multi-Company database PinmemberMycroft Holmes3-Oct-12 9:02 
Questioncannot find column [modified] Pinmembersindhuan1-Oct-12 1:19 
AnswerRe: cannot find column PinmemberEddy Vluggen1-Oct-12 2:00 
QuestionHow to Recover Deleted rows from sql 2000 Database PinmemberRobymon30-Sep-12 21:38 
AnswerRe: How to Recover Deleted rows from sql 2000 Database PinmemberEddy Vluggen1-Oct-12 1:57 
AnswerRe: How to Recover Deleted rows from sql 2000 Database PinmemberShameel3-Oct-12 6:46 
QuestionWindows Run Command Pinmemberjojoba201129-Sep-12 0:08 
AnswerRe: Windows Run Command PinmemberEddy Vluggen29-Sep-12 3:41 
AnswerRe: Windows Run Command PinmvpRichard MacCutchan29-Sep-12 3:58 
AnswerRe: Windows Run Command Pinmemberjojoba201129-Sep-12 6:12 
GeneralRe: Windows Run Command PinmvpRichard MacCutchan29-Sep-12 7:09 
QuestionRe: Windows Run Command [modified] Pinmemberjojoba201129-Sep-12 10:26 
AnswerRe: Windows Run Command PinmvpRichard MacCutchan29-Sep-12 22:29 
GeneralRe: Windows Run Command Pinmemberjojoba201129-Sep-12 23:40 
GeneralRe: Windows Run Command PinmvpRichard MacCutchan30-Sep-12 2:01 
QuestionRe: Windows Run Command Pinmemberjojoba201130-Sep-12 5:58 
AnswerRe: Windows Run Command PinmvpRichard MacCutchan30-Sep-12 6:13 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.141216.1 | Last Updated 18 Dec 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid