You and I go way back, Sergiy...

That's the one... too bad SQLServerCentral doesn't work for...

I'm the guy that coined the phrase.  I used in a lot in posts but had just started writing articles way-back-when.  IIRC, the first time I used it in an...

I have 10 different tables holding different set of transaction data(no relation at all). Just to standardize the data for reporting i have introduced key columns and loaded the...

Thanks, Steve.  I thought there was a new setting I didn't know about yet. 😀

We hit a problem when our  2014 SQL instance went from Standard to Enterprise to enable more Memory,

Everything was slow - but I had been pushing for DBLEVEL changes...

Unless you're like me and have done your level best to convert all SSIS...

Think about it: they consider xp_cmdshell is a security risk, and SolarWinds is not.

Go figure.

Not to mention PowerShell - administrative scripts requiring ultimate access rights are executed by a...

That's a very good point, and I understand your reticence.

Actually I'm not at the moment, but have in the past needed to do "unusual" things which would have been...

One of the things about SQL Agent is that it has worked fined, failed safe, and drained to the bilge quite nicely since I can remember.  It does have a...

We went through the same brew-ha-ha when we shifted from 2012 to 2016.  It was the cardinality estimator.  When we started the trace flag to use the legacy CE server-wide,...

All true, especially since you've implied that "It Depends".  And that's the point I'm trying to make.  Row compression is not a panacea and it should not be a "Standard...

Heh... it's not the security...

I've never seen an UPDATE pattern that bizarre in over 30 years in IT.  From 6 to 16,000,000?  I can't even imagine the business case that would cause 1...

I still prefer my single int as a metakey method.  16 bytes is a lot of overhead for a linking key.  I don't see an advantage to it.  And...