Viewing 7 posts - 1 through 7 (of 7 total)
Firstly David Burrows thank you for making me feel like an old goat. Having said that how many newbies have no clue when...
December 8, 2005 at 5:19 am
'Number of Account Enquiries queries per day 4200' -- This refers to the number of physical account enquiries our staff do on accounts when people call in and ask for...
October 28, 2005 at 5:31 am
'Number of Account Enquiries queries per day 4200' -- This refers to the number of physical account enquiries our staff do on accounts when people call in and ask...
October 28, 2005 at 4:39 am
We do the two jobs as well as the following,
Full database backup. Database Consistency checks, Rebuilding Indexes, Update statistics
October 27, 2005 at 11:18 pm
Nope been going on for a while since the begining of Sep when we centralised the Db's into one. We just not getting anywhere at the moment and need more...
October 27, 2005 at 8:39 am
We run the std sql optimiser this is done before and after the backups.
EXECUTE master.dbo.xp_sqlmaint N'-PlanID 664D0E61-8032-4E0E-821D-56F6BF7A2A36 -WriteHistory -VrfyBackup -BkUpMedia DISK -BkUpDB "E:\OffLine\Daily\0600" -DelBkUps 1DAYS -BkExt "BAK"'
EXECUTE master.dbo.xp_sqlmaint N'-PlanID...
October 27, 2005 at 8:04 am
We have been running profiler and modifying long running queries.
Currently most queries execute in 15seconds with odd ones at larger sizes
No changes have been made to the application which is...
October 27, 2005 at 7:51 am
Viewing 7 posts - 1 through 7 (of 7 total)