Gary Varga (12/2/2015)

---

It's tricky.

Companies do not like paying vastly different salaries/rates yet need different valued people. All of whom need both time to keep any necessary skills up to date...

Alan.B (12/1/2015)

---

I think there are three problems:

1. The genuine need for talented data pros is growing much faster than the supply of talented data pros.

2. Many (perhaps most)...

I think the year hasn't gone super fast. As I look back at what happened. It seems ages since I was in South Dakota this summer on vacation and for...

Even cache databases have issues here at scale. If you can somehow shard/federate your data, then perhaps you can use multiple systems to do this, but it's not a simple...

With regards to compensation, when I managed 10 DBAs, 9 of them made more than me.

I'd say that plenty of teams argue about names and formats. Whether it's formal or informal, each of us has preferences.

Agreeing on some is good, but also have tools for...

Upper management doesn't always know what happens with auditors. I've been in Fortune 100 audits where subject matter experts dealt with auditor details and provided data to auditors prior to...

Scott,

AFAIK, you are correct. SQL Server doesn't grab the max memory on startup. However it does grow, primarily through caching data, and will often grow quickly to the max under...

As Grant mentioned, the memory isn't the issue.

Slowness ~!= memory. They may be related, but may not be. Likely if your server is slow, it's not because SQL is using...

Gary Varga (11/30/2015)

---

Eric M Russell (11/30/2015)

---

...For example, a shopping cart for an ecommerce website is not the same thing as a purchase order for accounting, and only when the customer...

You said it was capped at 41GB. It will always grow to 41GB as you use the server.

No concern, no curiosity. This is how SQL Server works. Every query reads...

Are you saying that 41GB is high? If you set the max to 41GB, the SQL Server instance will use 41GB. All the RAM that isn't needed for queries is...

Agree with above. If you have a 2 node cluster then if there is a failover, you will be sharing 64GB among three instances. If you don't set max/min for...

Congrats, and glad you made such a big change and meet your challenge

You need to build two things.

1. How do I examine the data and determine if the current execution is long. Meaning, am I looking at the mode, the average, weighted...