No. when the cluster service is stopped on the 2nd node, it is evicted...

just trying to understand your question.

If you meant "Will fail over occur when...

your measure can be created based on the amount of sales * cost per product.

You can use the DMV to monitor the values: sys.dm_os_wait_stats

a good explanation on the types and what they mean on MS site below.

http://msdn.microsoft.com/en-us/library/ms179984.aspx

The general rule I know is: 1 data file per logical or physical processor (i.e. a SQL Server 2005 running on 4 quad-core cpus -> 16 cores should have 16...

Hi Ananda, please have a look at the link below..

http://blogs.msdn.com/b/psssql/archive/2009/06/04/sql-server-tempdb-number-of-files-the-raw-truth.aspx

Contact Pragmatic Works.

http://pragmaticworks.com/services/training/Default.aspx

GilaMonster (1/4/2012)

---

Henrico Bekker (1/3/2012)

---

How can I convince my manager, and company that its a great idea to send me to SQL 2012 Launch?/quote]

I'm not even trying. I have a very...

Everyone's view might be different but should mean the same thing at the end, so here goes:

1. What is Business Intelligence ?

Making sense and adding value to your data, visualising...

Our department, comprising of Technical Specialists and Sales People, have adopted the policy that no product or service will be sold to any customers without the involvement from the people...

I assume you are somewhat new to SQL Server, so here are a few good links to get you started.

http://www.sql-server-citation.com/2009/05/how-to-secure-sql-server-sql-server.html

http://www.sql-server-performance.com/2002/sql-security/

http://searchsecurity.techtarget.com/news/873207/Top-10-SQL-Server-security-blunders

http://www.bradmcgehee.com/2010/09/sql-server-security-checklist/

http://sqlsecurity.com/FAQs/SQLSecurityChecklist/tabid/57/Default.aspx

Some material may be outdated, but you'll get the basics and...

How can I convince my manager, and company that its a great idea to send me to SQL 2012 Launch?

http://devconnections.com/shows/sp2012/default.aspx?s=185

flying to the USA from South Africa and accommodation will be...

Its the same as your primary cluster.

I would however recommend using the current passive node as the active node for your second cluster.

I am pretty sure...

MS ACCESS?