below86 (6/29/2016)

---

I had my SSC account tied to my work email, and the password was saved by IE. So when I lost my job and couldn't remember the password...

Definitely more complex, but has the advantage of not being dependent on tools in the future. It's got more places things could break, but they could also be recovered.

However, there's...

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