higher clock speed with less cores will help with licencing

webrunner (10/4/2016)

---

Hello experts,

I'm planning an upgrade from SQL 2012 Enterprise Edition to SQL 2016 Enterprise Edition that also includes a physical-to-virtual switch of our cluster.

Does anyone know of any...

roneri75 (10/6/2016)

---

Have you tested to create a database in SQL 2016 with a user that only have the dbcreator and public server roles and got any other result?

Is there a...

when a user has the dbcreator server role and they create a database they are set as the database owner. This allows the user to inherit the DB_Owner database role...

from what I'm reading you're creating a new listener each time and not adding extra subnet IPs to an existing listener.

Just add each subnet IP to the existing listener configuration

Be aware this is not ideal or...

Exactly what I've been saying

execute in a loop or cursor

bugg (8/31/2016)

---

Perry Whittle (8/31/2016)

---

keep the tempdb data and log files on the same disks away from user database files. If you can put tempdb log onto a separate disk then...

Fly Girl (8/30/2016)

---

I got my first look at it yesterday and it has a single, 1.63T drive, RAID 10 with 6 drives. Zero partitions. All the databases that have been...

keep the tempdb data and log files on the same disks away from user database files. If you can put tempdb log onto a separate disk then do so.

do not...

master, msdb and model should just be left as is, no need to separate them.

Can you list out the cluster resources, use this powershell command

Get-ClusterResource

A separate service account for each service is of course the best practice for securing your SQL server services.

However, with Availability Groups, all replicas that participate in a group with...

Igor Micev (8/19/2016)

---

Hello All,

I have a two node cluster. Let's say N1 is the active node and N2 is the idle one (UP in the cluster manager). I want to...