CirquedeSQLeil (4/21/2010)

---

This...

WayneS (4/20/2010)

---

SW_Lindsay (4/20/2010)

---

Nice and helpful article - Thanks. Just Curious...

To select eligible candidates in the first select you say

select * from @Candidates where MeetsEligibility = convert(bit,1);

Why do you...

I imagine it means that it is one of a few (or even only) VM sitting on that hypervisor,...

dma-669038 (4/15/2010)

---

Am wondering if people would be willing to share more on their experiences with self learning - ie learning from home, install developer edition and so on. I have...

Clustering is essentially invisible to the app, but mirroring needs to know about the mirror server(s)....

Other than HA, you haven't actually stated what the requirements are - what does HA mean to you?

Questions to ask:

* how long can you afford to be down?

*...

Tom.Thomson (4/6/2010)

---

The "MS Revenue Centre" point is one we should all understand (and they are a Revenue Centre for the sort of training company that wants to blitz some short...

Although a witness can be used for asynchronous, there is no point as the databases won't be in sync and a failover would almost guarantee data loss. It also...

The witness can be any edition of SQL on any machine with network connectivity.

I will assume that you are referring to synchronous mirroring (high safety). If the primary site...

As Paul said, you really need to understand parameter sniffing to resolve this correctly. The performance impact *may* be due to recompiling every single time this proc is executed...

If you are running the backup through an agent job, check the job history. I usually have my jobs log to a file as the agent history truncates any...

fyi, compression is allowed in 2008R2 Standard Edition.

blandry (3/30/2010)

---

The best DBAs that I have seen, worked with, or had work for me, DID NOT have certifications. They had what I would call "battlefield experience". If...

The user would need to have either ownership of the schema or control/alter permissions on the table. The means of connection to the server is irrelevant.

You know which one was supposed to be the principal, you just have to confirm that it didn't failover - that event would be logged in the SQL logs if...