And you say...

Disregard previous post! 🙂 ...

I am actually deploying a Virtual SQL 2012 Cluster following this guide. Here's the quick software list:

-VMware Workstation 9.0

-freeNAS 8.2

-Win 2008 R2 evaluation ed.

So far so...

Thanks for sharing.

Perry,

Do you think I can use this as a guide for a SQL 2012 Cluster? Planning to do...

@anthony-2,

Thanks for sharing that piece of code. I'll take a look

Now, not trying to be a "pain in the butt" but how a cursor can be bad on...

anthony.green (11/20/2012)

---

I wouldn't use a cursor that's just asking for trouble.

I will attach the copy of the script I use tomorrow which utilises the above script and inserts to a...

Agree!

But this is for my own reports, nothing...

Wow! Nice thread ... 😛 .. just reading was fun!

I've seen both sides of the coin (IO and page contention), when I was working for HP. So I know 1st...

Here's the full and final T-SQL code...

--COLLECTING INFORMATION

CREATE TABLE #TempDBSize(

[name] [varchar](100) NOT NULL,

[database_id] [int] NOT NULL,

[Size] [decimal](10, 2) NOT NULL,

[UsedSpace] [decimal](10, 2) NOT NULL

)

EXECUTE master.sys.sp_MSforeachdb

'

USE [?];

INSERT INTO ...

Use COLLATION clause in one of the joins .. 😉

If you have a database with a different collation like me, you'll get that error.

It looks that what I was needing, was a lunch break ... 🙂 ...

Got the solution myself. Posting in case someone else is looking for the same ...

SELECTSD.name,

MF.database_id,

CONVERT(decimal(10,2),(DF.size/128.0))...

Thanks Perry,

I'll take a look today ...but regardless , with a max of two failover instances on a two node clusters , would you recommend mount points? Besides gaining more...

alanspeckman (11/13/2012)

---

A bladelogic scan indicated one node of the server was at SP1. After I failed this test server over, I was able to see SP1. I just...

SQL 2008 Cluster setup needs to be run twice (on a two node cluster) So you will end with two binaries install, one per node. This is different from SQL...

GilaMonster (11/12/2012)

---

Sorry, chapter 4.

Jonathan details his algorithm for calculating the max server memory for any value of total installed...

Thanks for reply.

Do you mind be more specific?

I actually have the paper book version at home. Re-download the free PDF version after your post. Chapter 3 is...