We use an ETL sofware from (SAP) and we use Buisness Objects (reporting software)
Our DM (DataMart) is giving poor respons ( i am told).
1. How do i get hold of the Queries (sql statments) from the ETL software and BO
(Reporting Software) which runs on the DM. ( 2 tables i am told)
2. Once i get hold of the SQL than i can optimise the indexes.(which i need help too?)
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied?
You can use SQL Server Initialize from Backup…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…