Andre Carrier (4/29/2015)

---

- setup new windows 2012 cluster

- install an initial sql 2014 test clustered instance

- test a migration by scripting logins, jobs, security, ssis etc. then backup-restore or...

check my stairway article on this site starting at this link[/url] for more help

A filegroup can only be removed once it has no files remaining.

Did you create a new filegroup or did you just add files to the existing filegroup

it's all detailed here

N.D (4/22/2015)

---

I have some more information -

The queries that are suffering from contention are selects. The db ID in sysprocesses definitely shows as the user database and we're now using...

arrjay (4/22/2015)

---

Hi there - I need to create a named instance on a sql cluster.

How do I perform this? Is it as simple as creating a named instance...

Careful here, my stairway series article at this link[/url] details the following

Stairway to HA Level 6

---

Impact of Row Versioning

When you enable a...

krypto69 (4/16/2015)

---

Hi,

I have a SQL2014 server using high availability. So there is a primary and a secondary.

There is a vendor process that pulls allot of the data from a large...

Are you wanting guidance to ask these questions to a potential candidate or brain dump them so...

If you want to fail...

I'd be granting a lot more than 12GB to the...

mxy (4/15/2015)

---

thanks for your prompt response. So we can run multiple secondary's with different interval I guess LS uses LSN number to determine which it is applying. am I right?

My...

correct

Maxer (4/15/2015)

---

it has no concept of...

This does not guarantee access to the file(s)

right click each file and select the properties then switch to security tab,...

Maxer (4/15/2015)

---

This is likely a simplistic question but I'm having trouble finding explicit documentation on this:

Say I have 2014 AlwaysOn setup and working:

SQLNode1 ->Instance01

SQLNode2 ->Instance02

When I setup my listener: ...