Perry Whittle (8/16/2011)

---

That's not entirely correct!

High Safety - High Availability and High Safety - High Protection modes will still allow connections to the database even when there is a mirror...

Patrick Purviance (8/16/2011)

---

In High-Safety/Protection/Synchronous mode, you're in a two-phase commit situation, so having the mirror offline is not an option. If you don't have a monitor in place for...

Since I wasn't sure of what was happening in High Safety (sync mode), I switched to High Performance (async mode) this morning.

Here are the results of the query:

365A10FF5D-4F04-4009-8A0D-6478CF04D1894SYNCHRONIZED1PRINCIPAL11OFF2TCP://server.domain.com:5022server\instance0UNKNOWN9765300000024670000110NULLUNLIMITED9765300000024670000197653000000246700001

High-Protection(synchronous)

There is no witness server.

BCC-493036 (7/22/2011)

---

In your SSIS package, is there a step to export data to Excel? If yes, you are using 64 bit SSIS which does not support Excel driver. You need...

Alright, I know why the OCI error is occurring - because I changed the oracle connections to be 32bit.

Now, I get this error when trying to run in 64 bit.

Description:...

Sorry, I guess the error message would be helpful. =)

Error: 2011-07-22 12:07:50.12

Code: 0x000002BE

Source: Data Flow Task [61]

Description: Failed to load...

james.morrison 19355 (7/7/2011)

---

Highlight the server name. Right click, Properties.

There is a line called "Memory". You can set your maximum SQL Server memory in that screen.

It is in MB so for...

True. I always forget about Powershell. I've learned how to use it, but have not had a chance to leverage my skills. Thanks!

Yeah,...

Steve Jones - SSC Editor (6/20/2011)

---

It's a load issue, not a number of databases. I know people that have had upwards of 500 databases on an instance, and it's worked...

Lowell (5/18/2011)

---

DBAgal (5/18/2011)

---

I inherited a database where the db users were granted db_ownership. After spending hours on the phone yesterday explaining the db change management process, the developer was...

I'm going 🙂

I am actually just using an admin tool (Quest's Performance Analysis) that just displays it as "Latch Buffer Wait". When I ran "SELECT * FROM sys.dm_os_latch_stats," I am seeing...