The question was "... What can I do? (choose 2)."

Not must, or should, but can. You don't need View Server State to kill the jobs. This is required to view...

I'm in the both camp. I use SQLCMD to do lots of simple stuff, it's easy to work with and I'm comfortable.

However, when I want to do more scripting that's...

Beatrix Kiddo (1/9/2017)

---

Quick random question that isn't really worthy of its own thread. Given that the log redo process in an AlwaysOn Availability Group secondary can be likened to a...

aalberyo (1/9/2017)

---

Hi friend,

Compile talks about Store Procedure for the DB. Basicaly is modify and optimize of tables and indexes incorporated a one field of a table, compile an SP it...

We try not to create extra screens for clicks. The forums should be about the same, maybe slightly styling differently, but not really more/less information.

Are you looking for a platform or hosted VMs with a database software running?

I'm wondering how you want to compare SQL Server v PostgreSQL as well. Aren't there different costs...

Read Gail's post. It does a good job. Essentially, a compile produces an execution plan that is then run to return (or change) data. That's similar to compiling a C#...

There are multiple IP addresses for your host. You need to set them all to 1433, if that's what you want.

Be sure that only one SQL instance is on this...

However, not everyone...

Thanks, will take a look, likely Mon.

gsc_dba (1/6/2017)

---

Contradiction here: 3 people:

https://mvp.microsoft.com/en-us/PublicProfile/4014238?fullName=Steve%20%20Jones

I have worked with all versions since that time, primarily as a production DBA at all sizes of companies. During my career I became interested in...

I am really hoping I get to 1 before you get to 3.

Eric M Russell (1/5/2017)

---

Broadly speaking, I'm free market and libertarian when it comes to cultural freedom and limiting government. However, when it comes to privacy and data security, I believe...

Moved this to the SQL 2012 forum.

I see in the errors the heartbeat is lost. Are your two (or more) nodes on a separate network? Or are you sure there...

Phil Parkin (1/5/2017)

---

Luis Cazares (1/5/2017)

---

Maybe you were selling kitchens? Or fake...