90 days. good deal. I haven't seen that printed yet..

I try not to go to enterprise unless I need to, basically due to costs. But if you need...

We'd love to hear back..

And the AWE setting in 64 bit is effectively ignored, not sure why its even there in that edition, probably backwards compatibility.

If you set it to...

I'm going to pile on what Gila and Lowell have said.

STOP RESTARTING SQL..

Unless you have other software installed you have effectively set aside 14GB for the OS and SQL performance...

I would say that they are inter-related. SSRS and SSIS are components of the BI suite for MS SQL Server..

CEWII

handkot (2/21/2012)

---

select @@VERSION

Microsoft SQL Server 2008 (SP3) - 10.0.5500.0 (X64) Sep 21 2011 22:45:45 Copyright (c) 1988-2008 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT...

Kind of feels like homework..

CEWII

calvo (2/21/2012)

---

Depending on your licensing you should only need to license the active instances. Now there are rules governing this process so be sure to consult microsoft documentation or give...

I think you need to understand the cluster quorum settings because for a three node cluster the only way to allow a 2 of 3 failure is the No Majority...

I'm saying that you could have the new nodes and the old nodes as part of the cluster at the same time. What matters is the number of machines...

I'm a little worried that you fundamentally don't know about max memory in SQL. As said above SQL will use ALL the memory it wants if you don't expressly...

At a high level I believe it will work. I don't believe the nodes have to be evicted from the cluster for it to work just that SQL Standard...

My first thought was a name resolution problem..

CEWII

Service Broker sounds like a good alternative.. Fire and forget..

I try VERY hard to limit the use of linked server, I used to use them often.. ...

SQLKnowItAll (2/14/2012)

---

When talking to Microsoft about this, they said any person or device directly or indirectly touching the SQL Server requires a CAL. For example, if a website touches SQL...

That makes sense devin.. I believe the order of precedence is:

1. design-time values

2. run-time startup values

3. config values (files, SQL, environment, etc.)

4. execution values

CEWII