Just script your backup with T-SQL and set up an agent job on each server to execute that script. The first step in the script can check if the...

We use the PolyServe Matrix Server Database Utility for SQL Server to run 2 distinct 5+1 'clusters'.

http://www.polyserve.com/sql_server_consolidation.php

They push it as useful for consolidation, we went with it to...

The virtual SQL Server has a different IP address from the cluster itself. Network names, such as SQLET01, are resolved into IP addresses through DNS. A single network...

Using windowed aggregates (using the OVER clause) avoid the messy join-back stuff:

SELECT n.caption, AVG(b.availability) AS Availability, AVG(AVG(b.availability)) OVER () AS 'Average of Availability'

FROM nodes n INNER JOIN

...

DevTeamLead (10/5/2007)

---

Hoping this trickles back to the lair of the Architect...

One of the most disparaging things I run across in SQL code is the use of;

SELECT *

[...]

-Microsoft promises to deprecate...

There's a lot of info in that book that is related to tuning hardware and windows server monitoring, which is valid info regardless of the version of SQL Server. ...

From http://www.microsoft.com/sql/editions/enterprise/comparison.mspx

High Availability “Always On” Comparison

SQL Server 2005 Standard Edition

Failover clustering

Two-node only

SQL Server 2005 Enterprise Edition

Failover clustering

Up to 9 nodes

-Eddie

Use datepart to get the day of year:

SELECT datepart(dy, getdate())

If you wish to use snapshots, but be able to change the data displayed in the report, then use Filters.

Parameters are applied before the data is stored in...

Databases upgraded from SQL Server 2000 to SQL Server 2005 will remain in SQL 2000 compatibility mode (mode 80). To switch the compatibility mode to SQL 2005 (level 90),...

Contradicting an earlier post, PolyServe has nothing to do with load balancing. It's just a different kind of clustering (shared everything vs. shared nothing).

This sort of situation is where the windowed functions get really handy.  In this case, I'm referring to the RANK() function.  Rank calculates a 1..N value for sets of rows...

A good technical interviewer (who's doing more than simply validating you told the truth on your resume) will *always* go over your head, in several directions outside of the job...

try this instead:  ...values (19,'2005/12/05')  (note the single-quotes around the date)

Without quotes, SQL Server sees 2005/12/05 as 2005 ÷ 12 ÷ 5, which rounds to the...

Our application does over 200 million inserts a day, and we use a 15-minute log backup frequency.  Your thoughts - better recoverability and quicker backups vs. taking fewer log backups...