GSquared (6/29/2016)

---

The usual way to do that is to rebuild the clustered index into the new filegroup ("CREATE INDEX WITH DROP_EXISTING" is one way to do that, if I remember...

Leonard,

You're probably right in some sense. I guess it depends on how we look at grunt work. For example, we will always need someone to rack servers and move equipment.

However,...

Cheers

First, your link is broken. It doesn't matter what your SSIS process is. What we need is some test tables and DDL and data. Please create a table that mimics...

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...