Does anyone use the application "PROMODAG" in their
network? If so can anyone tell me how to optimize the
database the application creates on sql server?
Another question would be, before it imports from the
logs, if i remove any indexes it may have as well as
primary keys, will this affect the application? I have
tryed to look stuff up on the net but found nothing... any
advice is welcome!I don't know PROMODAG personally, but removing the PKs & indexes from any
database will degrade performance for any application. If you're performing
a regular data load & no users are on the system whilst the PKs & indexes
are removed, this might help the load process, but you'd almost certainly
need to replace those PKs & indexes after the load.
HTH
Regards,
Greg Linwood
SQL Server MVP
"
" <anonymous@.discussions.microsoft.com> wrote in messagenews:fe8301c411b9$97d0ec10$a601280a@.phx.gbl...
> Hey
> Does anyone use the application "PROMODAG" in their
> network? If so can anyone tell me how to optimize the
> database the application creates on sql server?
> Another question would be, before it imports from the
> logs, if i remove any indexes it may have as well as
> primary keys, will this affect the application? I have
> tryed to look stuff up on the net but found nothing... any
> advice is welcome!
No comments:
Post a Comment