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

As a boy, I helped my father dig trenches for water pipes, cut trees, plow firebreaks, and build simple structures. I always enjoyed knowing how things went together and...

I've found that doing and creating things in the physical world is critical to my mental health.  Working in IT the vast majority of my work hours are spent...

I'm going to throw in something different on this topic. I hate cooking. If it were up to me, I'd make PBJ sandwiches all the time. I like PBJ...

I also enjoy accomplishing things around the house.  I have never tapped a bolt, nor do I have the tools for it.  But it is something that I would...