I'll echo Grant's statements. While 2014 introduced a new cardinality optimizer, there aren't a lot of changes for many queries. They do keep trying to improve the way the optimizer...

How do you know what features are there or missing? Is there a list of features?

I would always go latest. You're going to pay for that anyway, and with the 10yr lifetime of patches, anything other than 2019 is already digging into it's lifetime. Features...

Edit: Had noted LAST VALUE, but that's not helpful here.

• This reply was modified 5 years, 5 months ago by Steve Jones - SSC Editor.

I am interested in what you mean? I know some organizers wanted to have a different logo. I see both sides on this, but I'd support allowing different ones. I...

Please post the DDL for the table and an insert statement for data. (CREATE TABLE and INSERT..VALUES)

This will help us help you find a solution. Show the results you would...

While you can upgrade, I'd do a side by side migration. This is lower risk, and if things go wrong, you have a backup.

I would do this:

• Install news Windows...

It does note pandas is loaded. I've updated this to say "as pd"

I like those kinds of thoughtful questions. The best interviews I've had have used those, working through some process or scenario rather than looking for trivia.

If the app gets changes, then an upload is immediately correct. You said that a job doesn't work because it could take a minute to show changes, but those would...

the industry also has a track record of many improvements that are improvements. Hence my post. It's easy to be too negative or positive. I am striving for a balance...

If the app loads this, why do you need the dir command? Don't you know where attachments are stored? If you use Filetable, you'll have a known share (\\server\share\path\file). If...

Wow, I learned something, too. Glad to see a unique index is enough, as it should be.

You need a PK to create a FK.

Apologies for the delay in responding.

We are not creating an organization or a PASS 2.0. We bought the assets, and we are looking to run conferences in the future. Likely...