Perry Whittle (9/25/2012)

---

opc.three (9/25/2012)

---

I didn't think locked pages were part of the working set which is why Task Manager lies to us but maybe locked_page_allocations_kb is not what I am...

Please be careful handiing out that advice. There are most certainly some DMFs that can cause issues and...

If you have found fragmentation or low scan density and you want to run a daily job to remediate it I would recommend looking into this:

http://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html

As far as I know MemToLeave should be part of the working set, so yes, if I am understanding the columns...

I didn't think locked pages were part of the working set which is why Task Manager lies to us but maybe...

You're welcome.

To be clear sa is implicitly the...

A little Google never hurts either:

Integration Services Tasks

The dbo of a database has full rights in that database, including the ability to drop the database. Also being a member of the db_owner role offers no additonal permissions.

sqlguy-736318 (9/19/2012)

---

I think it's unfortunate that MS doesn't provide an automated tool to review a SS database for standards compliance. The nice thing about FXCop is that it's somewhat...

Install SSDT and open the SSIS package in SQL 2005 format.

From Upgrade Integration Services Packages Using the SSIS Package Upgrade Wizard:

When you open an Integration Services project that contains SQL...

We get various dials and switches to tweak and adjust, it's up to you to apply them appropriately for your system:

- MAXDOP query hint

- Max Degree of Parallelism

- Cost Threshold...

DLathrop (9/24/2012)

---

I've wondered at the optimal setting also.

We have a problem with MAXDOP=0 in our environment. We are very lightly loaded at night, and only have a few large queries...

Amount of memory being used for the buffer pool:

SELECT CAST((bpool_committed * 8) / (1024.0 * 1024.0) AS DECIMAL(20, 2)) AS BufferPoolCommittedMemoryGB

FROM sys.dm_os_sys_info;

It looks like you're running into an issue with a stored password. Are you saving the sa password in the Connection Manager in the SSIS package? If so then what...