Yes I agree that it could come in handy to add a third data center fileshare vote. I see where you are going with this and it all makes sense...

Perry Whittle (7/16/2012)

---

That's just it, with a 3 node cluster you should be using the default which is node majority. You wouldn't ever take SQL02 and SQL03 down at the...

Perry Whittle (7/14/2012)

---

Why would you want to start rebooting cluster nodes when you're cluster is already compromised? Work on getting the site back should be the priority. If you're DR...

Perry Whittle (7/13/2012)

---

If both nodes are on the same site you would typically use a shared disk resource, although a fileshare witness would also suffice. Are they both on the...

According to the Microsoft SQL Server AlwaysOn Solutions Guide for High Availability and Disaster Recovery, the way to determine the voting is as follows:

Recommended Adjustments to Quorum Voting

To determine...

Thanks everyone! This is perfect!

Wow thanks for the thorough replies and links! The only question is that in the link provided (http://www.jamesserra.com/archive/2012/04/sql-server-2012-multidimensional-vs-tabular/) it says that Tabular uses the existing data model and...

Shoot can someone move this to the strategies and ideas BI section?

In SQL 2k5 (not 2000) you should run sp_updatestats after this job and it will update only statistics that are needed.

It doesn't look like the @activeconnectionsindb variable is populated...

Grant Fritchey (3/6/2009)

---

The one thing I'd suggest, instead of trying to pivot the data into columns, return it as rows, you'll have fewer joins and simpler queries that way....

Grant Fritchey (2/27/2009)

---

No, that's probably not a great way to go about it. Instead have a many-to-many join table between the two other tables. So you'll have a ChangeRequest table...