Viewing 15 posts - 5,281 through 5,295 (of 18,926 total)
Yes have HIM write the code in dev. Test it in test server, prove it again in QA.
Then YOU execute it in prod after making sure you have a...
June 27, 2011 at 6:16 am
Navision is an ERP. So if you use simple mode and do full backups only 1 time per week then in the case of a disaster you lose up...
June 27, 2011 at 6:09 am
Ditto. Buy more space. Make sure you're backing up both the db and logs so the logs don't fill up the drive uselessly and don't ever delete data...
June 27, 2011 at 6:04 am
jvElecenter (6/27/2011)
Thx for all the replies.Ok, I've skipped the shrink part. It was still there due to lack of disk space.
I can't set to simple because of Navision
Kind regards
Where the...
June 27, 2011 at 5:58 am
shilpa.shankar87 (6/27/2011)
Hi Friends,Can anyone please suggest, using UPDATE STATISTICS is a good idea working on PRODUCTION environment or not??
Plz start a new thread. And yes it should be on...
June 27, 2011 at 5:41 am
And here's what I use to reindex... works great out of the box. No tuning necessary at first. I only recommend starting with higher than 10% fragmentation because...
June 27, 2011 at 5:39 am
This gives you exactly what you need. Small warning : I just found out it doesn't work right when the db has multiple data files. I haven't had...
June 27, 2011 at 5:36 am
You need sp_executesql.
June 27, 2011 at 5:34 am
Jayanth_Kurup (6/27/2011)
Is it worth the effort to identify table with high index fragmentation and then update stats for those tables more frequently instead of doing a full scan
I actually do...
June 27, 2011 at 5:33 am
Jayanth_Kurup (6/27/2011)
is it possible to try backup log with truncate with no log followed by the database backup, important to backup the data soon after to prevent data loss.
If you...
June 27, 2011 at 5:31 am
Grant Fritchey (6/27/2011)
June 27, 2011 at 5:18 am
dakshiw (6/26/2011)
Yes, WITH FULLSCANI decided to go for once a month job at this stage. Feel that's sufficient, Might keep weekly as an option.
Thanks Michael.
Not nearly enough.
The 1 issue...
June 27, 2011 at 4:58 am
matt.newman (6/23/2011)
June 23, 2011 at 11:42 am
Viewing 15 posts - 5,281 through 5,295 (of 18,926 total)