Pros, you can upgrade dev machines and easily move to other/new developers. You can work at home or remotely without changes.

Cons - bandwidth needs to be there. If there are...

I think this video also has some numa explanations: http://technet.microsoft.com/en-US/sqlserver/gg508899.aspx

As Gianlucca said, the idea is that memory is linked to a node so that it ensures resources are available for...

Eric M Russell (11/7/2013)

---

Ask 100 people how they would envision a "perfect" solution, and you'll get 100 different answers, only 10 of which are even remotely feasible. Implementing and deploying...

Tom John-342103 (11/7/2013)

---

In some business situations, time is of the essence. If a competitor rolls out a great new offer that requires you to change your systems, and you...

skeleton567 (11/7/2013)

---

If users have to circumvent your system to do their job, you have failed. If your support people are constantly handling quality issues and failures, you have failed...

The exact quote from the email I saw. I did not press further as to what "clunky" was, but...

There's a list here of well known ports: http://en.wikipedia.org/wiki/List_of_TCP_and_UDP_port_numbers

In the past, we've typically gone with 51433, just to make it easy for people connecting. However check to be sure it's...

Well, you can import encrypted data. It's just data like anything else.

However, it will be encrypted inside the database as well.

If the file is encrypted (not just the data), then...

I think that's a good estimate of what's being used. It's not what's needed, but it's what's in used based on the workload. You can't assume the same buffer pool...

I think once you get to know your users and company, often it does appear you have telepathy if you're good.

SequelSurfer (11/4/2013)

---

I'm thinking possibly not 😀

Not sure where that score came from but I'll definitely take it, and I had a 29.8...

L' Eomot Inversé (11/6/2013)

---

Good question.

Does the confict between the normal recommended cluster size for volumes holding filestream containers (64KB) and the size recommended for use when the filestream container is...

Preston Davis 19463 (11/5/2013)

---

I wish to complain. I picked your answer, which I know to be correct, and was mark incorrect. This is not the first time this has happened;...

Luis' code will work if there are always the correct number of digits stored. So September is 09, never just 9. If you don't always get the same number of...

Robert.Sterbal (11/4/2013)

---

The failures so far have been more political fighting than technical. Does anyone know where to look up the relative performance of the different exchanges that have been set...