We constantly run into communication problems !

That's about the biggest challenge of being a DBA :w00t:

Take a deep breath.

Now:

- refrase the question and the answer(s).

- try to use the...

BOL contains good info on indexes.

There are some nice articles on indexing at SSC :

- Introduction to Indexes (by Gail Shaw) : http://www.sqlservercentral.com/articles/Indexing/68439/

- Indexing Strategies (by Ramesh Gummadi) : http://www.sqlservercentral.com/articles/Indexing/indexingstrategies/1252/

-...

isnull is a proprietary version of COALESCE, but with just a single replacement value.

From BOL

ISNULL (check_expression ,replacement_value )

Check BOL: http://msdn.microsoft.com/en-us/library/ms184325.aspx

So the where clause will return only rows...

GilaMonster (8/4/2010)

---

Jack Corbett (8/4/2010)

---

Probably the most complex SQL I've had to write. Too many OUTER JOINs (business requires this design), and then parameters that could turn the OUTER JOINs...

Brandie Tarvin (8/4/2010)

---

CirquedeSQLeil (8/3/2010)

---

I have to disagree with this statement. As an amateur historian, I don't see the...

Duran (8/3/2010)

---

Hello,

OK, so the instances would failover and continue to be available on the one remaining node, so the hardware on each node would need to be powerful enough to...

I couldn't have done that better 😎

Very, very nice plan and bug analysis.

Who am I ? Sometimes this is me[/url] :alien: and most of the time this is...

That depends on your resource group settings.

By default - for sqlserver - it will be configured to become active at the onther node(s).

Keep in mind, this will be done at...

Jamie Wormald (8/3/2010)

---

If a resource fails on one of the sql instances what will make the server failover. The way I understand it only one server if live at any...

Your disk definitions need to be in the same cluster group as the one you want to install your sqlserver instance on.

Create a cluster resource group that only holds the...

Clustering a sqlserver instance (can host multiple user databases) is no problem.

Load balancing does not exist for sqlserver.

Off course you can load balance the applications, but when they get...

maybe this can get you started ...

select [Server]

, JobNaam

, JobEnabled

--, last_run_date

...

Good point.

Those are the apps that should be documented in a failover checklist.

At least they should be mentioned in the migration/upgrade plan for the db.

I doubt order is of any concern with the current versions (2005/2008).

You need to keep in mind the total length of fixed data types is still restricted to 8060...

- I would start with the SQLServer upgrade advisor (SQLUA).

This will point to potential issues with your database(s).

- I would also run the Best practice tool, to see how...