I think there shouldn't be time zones, let alone DST. The entire globe should be Noon, as an example.  Pick a time zone, and the whole world can follow...

I sent a note to MS on the MVP list to see if anyone has a link.

So I downloaded from here: https://www.microsoft.com/EN-US/DOWNLOAD/confirmation.aspx?id=50420

That didn't install as it says it's not newer than my current version, which is 2017.10.xx something. I think I got this from installing SQL...

Doh, good catch. Moving too fast when I typed in answers. Should be fixed now.

Now I'd like to play the Devil's Advocate and argue for HIPPO and against being data driven. For this, I'm going to use the history of tobacco and cigarettes...

Not surprised. A lot of software will check for updates or to send some sort of metric data back and if they don't get a response, they stop trying. However,...

Hi Steve,

So even if though the index approach should be the way I go, why wouldn't Scott's earlier code not work for me if I at least implement it...

There is no way to implement the request. There is no partition key on a non partitioned table

What do you mean replicate this? This is just a text file you can edit.

Sorry you didn't make it Ray, but hoping to see you somewhere later this year.

If you can image this machine, I'd try the repair there first.

I suspect it works in general, but they don't want to support any problems on 2014. I've run many systems out of support,and it's rarely been an issue.

However, when it...

No idea, and searching for this is hard. Too many PoSh things work with IPs.

I suspect that it (or the PS Gallery modules) have some hard-coded IPs they use to...

Gail's piece: https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/gail-shaws-sql-server-howlers/

You can't partition a column. This is for tables. A client asking for this doesn't really understand what they want.

Here's my thought.

While Johan is right, and you know splitting makes sense, it's not practical. I'd kick the can and assume we will need to split this, but try the...