Click here to Skip to main content
12,952,778 members (35,493 online)
   

Database

 
Questionterminating SqlConnection.Open() call while connecting Pin
Dan_K4-Oct-12 7:43
memberDan_K4-Oct-12 7:43 
AnswerRe: terminating SqlConnection.Open() call while connecting Pin
Shameel4-Oct-12 8:46
memberShameel4-Oct-12 8:46 
AnswerRe: terminating SqlConnection.Open() call while connecting Pin
Eddy Vluggen4-Oct-12 9:10
memberEddy Vluggen4-Oct-12 9:10 
GeneralRe: terminating SqlConnection.Open() call while connecting Pin
Dan_K5-Oct-12 4:37
memberDan_K5-Oct-12 4:37 
GeneralRe: terminating SqlConnection.Open() call while connecting Pin
Eddy Vluggen5-Oct-12 4:57
memberEddy Vluggen5-Oct-12 4:57 
QuestionSQL 2000 to 2008R2 Query Performance Pin
cjb1104-Oct-12 5:13
membercjb1104-Oct-12 5:13 
AnswerRe: SQL 2000 to 2008R2 Query Performance Pin
Shameel4-Oct-12 9:01
memberShameel4-Oct-12 9:01 
GeneralRe: SQL 2000 to 2008R2 Query Performance Pin
cjb1104-Oct-12 22:30
membercjb1104-Oct-12 22: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 Pin
David Mujica4-Oct-12 10:25
memberDavid Mujica4-Oct-12 10:25 
GeneralRe: Execution plan Pin
cjb1104-Oct-12 20:58
membercjb1104-Oct-12 20:58 
GeneralRe: Execution plan Pin
David Mujica8-Oct-12 8:54
memberDavid Mujica8-Oct-12 8:54 
GeneralRe: Execution plan Pin
cjb1108-Oct-12 23:41
membercjb1108-Oct-12 23:41 
GeneralRe: Execution plan Pin
David Mujica9-Oct-12 3:12
memberDavid Mujica9-Oct-12 3:12 
GeneralRe: Execution plan Pin
cjb1109-Oct-12 4:34
membercjb1109-Oct-12 4:34 
GeneralHigh CPU Pin
David Mujica9-Oct-12 9:13
memberDavid Mujica9-Oct-12 9:13 
GeneralRe: High CPU Pin
cjb11010-Oct-12 21:30
membercjb11010-Oct-12 21:30 
GeneralRe: High CPU Pin
cjb11010-Oct-12 23:15
membercjb11010-Oct-12 23:15 
QuestionMySQL Server timestamp changed! Pin
jrahma2-Oct-12 21:53
memberjrahma2-Oct-12 21:53 
AnswerRe: MySQL Server timestamp changed! Pin
Shameel3-Oct-12 4:05
memberShameel3-Oct-12 4:05 
QuestionConnection String for Ms access 2010 to Windows 7 64 Bit Pin
Satyam Tripathi2-Oct-12 21:33
memberSatyam Tripathi2-Oct-12 21:33 
AnswerRe: Connection String for Ms access 2010 to Windows 7 64 Bit Pin
Richard MacCutchan2-Oct-12 22:00
mvpRichard MacCutchan2-Oct-12 22:00 
QuestionBackup/Recover of row data in a multi-Company database Pin
DeDawg2-Oct-12 10:35
memberDeDawg2-Oct-12 10:35 
AnswerRe: Backup/Recover of row data in a multi-Company database Pin
Mika Wendelius2-Oct-12 11:17
mvpMika Wendelius2-Oct-12 11:17 
GeneralRe: Backup/Recover of row data in a multi-Company database Pin
DeDawg2-Oct-12 11:22
memberDeDawg2-Oct-12 11:22 
GeneralRe: Backup/Recover of row data in a multi-Company database Pin
Mika Wendelius2-Oct-12 18:22
mvpMika Wendelius2-Oct-12 18: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.


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 26 May 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid