Indeed, we've been using the custom application for years now (and it was tested thoroughly before it went into production) and never had issues with ordering (nor performance).

Btw, I...

Hi Jeff,

as always appreciate your responses & tips. I was being a bit short-sighted in that the app we use doesn't need the functionality to pick a specific part of...

Nice article. May come in use one day so glad you shared that.

Btw, I use bigint to store IP4 addresses (less space and able to use ORDER BY)

No one deserves 1 star so I gave 2. Why?

* windows 2003 is obsolete - in my opinion you should document the steps for 2008+

* you format the partition with...

Hello Hayward,

no unfortunately not. We've come to a point at which we're not going to install new instances on this cluster anyway so I doubt we'll ever find what caused...

Perry Whittle (5/15/2014)

---

george sibbald (5/15/2014)

---

Perry, thanks for the article.

If you have a test server on which you may restore backups from multiple prod servers how is that handled? Do you...

Hi Rich,

I feel your pain 🙂

The last few days I've tried more stuff, one of which was using a config file and a quiet installation for the ADD NODE task....

Hi again

been a while but just wanted to post an update, as promised.

I disabled all cores but 1 (per socket, so it left me with 2 CPU's) in the...

Hi guys,

yes, I'm adding 1 new instance that has 3 mount points (data, log, tempdb). There are already 8 2008R2 instances on that cluster. I'm installing on the passive node...

Perry, tried with and without updates, same issue unfortunately...

ok, thx for the update Andrew

Hi Perry,

the difference between installing an extra SQL 2008 R2 instance (about 1h) or an extra SQL 2012 instance (about 4h) is out of proportion though.

Chrz

Thierry

Thx for the tip Theo. I'll try this out next time I need to install a fresh instance.

Lowell,

this thread is about installing a clustered SQL instance, not about querying...

Chrz

Thierry

Hi Andrew,

no, not solved 🙁

I thought I was the only one experiencing this issue... The only difference I see is you're running a cluster based on Win 2012. So we...