What is the recovery model of the dw?

murnilim9 (7/10/2014)

---

Hi All,

At the moment I am tuning the indexes with high fragmentation ..I created a maintenance plan for rebuild /reorganize ( set the logic for fragmentation above 50%...

Before you start reorg'ing or rebuilding your indexes, ask yourself:

Are we actually having any performance issues with the database? What have your users said?

What is the profile of the...

Create a SSIS Package that store the Oracle datasource and Oracle login credentials e.g. Use a Configuration File to store these details

Deploy Package to SQL Server and Create a SQL...

arrjay (7/7/2014)

---

Hi there - I have set the max memory setting in SQL to use only 12GB however in the task manage it states that SQLSevr.exe is using 13.5GB. ...

Great information sharing, I'll certainly be bookmarking these links...

Hi Igor, so the steps in the article resolved your issue? or did you have to change any for...

nickm-917421 (7/1/2014)

---

We have CRM on a SQL 2012 Server, however no one in the company knows the SA password and there is no network account with SQL admin privileges either

so...

tripleAxe (7/1/2014)

---

If you can add your account to the local admins on the server and start the SQL service in single-user mode you can access the server and then reset...