I ask gently, but I really hate doing anything else. I don't always like where the discussion goes, but as long as it's not abusing or profane, I won't censor...

I'd prefer this not turn into some political discussion. Both sides, or really all sides, use these techniques to sway others.

Outside of politics, plenty of others use statistics and data,...

There's far to many. From sp_config to all the database settings. MS has not made this easy.

A few people have tried:

• https://sqljana.wordpress.com/2018/09/12/sql-server-compare-the-configuration-of-two-instances-using-sys-configurations/
• https://archive.codeplex.com/?p=scriptsqlconfig

I was looking at some shoes a friend recommended the other day on my laptop. When I opened a game on android, an ad for the company was at the...

The plans should be the same, if all knobs/config settings are the same and the data/stats are the same. If you mean you're attaching the database separately to standard and...

I'll still disagree. This might be as simple as a table for sales

ZipCodeLogic
Salesperson ZipCodeStart Reason
----------- ------------ ---------
1           0...

I don't like the "what's a clustered index?" or other trivia questions. Not because the knowledge isn't important, but it wastes time. As Eric noted, I want to ask questions...

This has been an interesting discussion.

I, too, despise magic numbers, especially when developers assume because they know it now, everyone in the future will remember.

I prefer a small lookup table,...

The Jones are doing pretty good, just to be clear.

I find lots of companies that want to move to DevOps get into the shiny ball syndrome. Google/Spotify/et al did it,...

I have always set autogrowth, by some amount, not %. I make sure each file in a db has the same settings.

However.

If autogrowth executes, I take this as a personal...

If you think advertising isn't effective, you're not aware of the world.

It is hugely successful.

The ads are prepurchased, so it's not the company. It's the advertising medium that is broken here. There is no linkage from your purchase to the decision to show you...

I like the cross apply, but not sure it's needed here.

Going back to the original, asita, is the goal to bucket rows for a report of some sort? what's the...

Audit and xEvents can capture this, but it's not a rolling level. You'd get a lot of data back. Potentially you could capture, periodically read a window of data and...

Why doesn't the CASE work for you?