Rod at work (6/28/2016)

---

Steve, your commentary makes me think that there's a high demand for data scientists. Either that or it pays well. I've not looked at the job market...

porter.james (6/28/2016)

---

As much as I'd like to think our organization could use more data scientists, the reality is that the most accurate statistical models delivered by my colleagues were rejected...

Jeff Moden (6/25/2016)

---

While I agree that it probably has fewer bugs that previous releases, this one broke a whole lot of...

Gary Varga (6/28/2016)

---

I am not suggesting there is not improvement. I am just saying that if in year 1 there is a SQL Server release which goes well and then...

Brain2000 (6/28/2016)

---

There were two items in this article that I feel need to be clarified.

The article stated that cumulative updates are not fully tested like service packs. While this was...

kmn334 (6/28/2016)

---

Don't forget to install CU1 which came out 2 days after launch. Fixes CDC and potentially crashes that don't generate error messages. Bob Dorr wrote about it...

Bad installer. You need to get the version for Express with advanced services. So, uninstall/reinstall or add a named instance.

The 2016 forums weren't expanded by default. My apologies for...

It's not quite clear what you mean. I think you need to provide more DDL and sample data to show something.

If you're matching on 'Wed', then isn't F10 always Wednesday,...

To add to what Jeff said, once you use the Table Designer to make changes, don't click "save".

Instead, use Table Designer | Generate Change Script or click the icon that...

I'm not sure. I believe that the underlying WSFC can work for an AG.

As far as using the database in the AG for SSAS, I assume using the virtual instance/db...

I understand concerns, but remember, Jeff, no code is ever unchecked. Part of the process is ensuring that code runs through a set of checks, whatever those are. Those can...

Don't confuse clustering (WSFC or FCI, depending on Windows version) with Availability Groups. They're separate.

I'm not an SSAS expert, but there isn't a database per se, correct? Isn't there a...

I think you can do this. It appears the WSFC will work with SSAS, which I think means NLB isn't needed. The resource should appear as a clustered item with...

I think I was confused as to what you were looking at. I see now since there aren't two CustomerName items in each element that there's a good chance that...

TomThomson (6/23/2016)

---

Not a very good question, because the answer (at least for SQL Server 2012, SQL server 2014, and SQL Server 2016) depends on whether the index is partitioned or...