<sigh>

You're killing me here.

Yep....

If you have specific questions, never hesitate. We try to be helpful here. If we can help someone get a job or an employer get a good DBA, all the...

It's not just a seek versus a scan issue here. There are a whole slew of differences between these two queries, even though it looks like the result sets are...

The bad news, finding a good dba is really hard. My last company went into a semi-permanent recruiting mode when it took us over a year to find a single...

Recovery Time Objective (RTO) is not determined by what you back up or how frequently. Well, it is, but not the way described here. It's about how long it takes...

Solarwinds should have a way to tell you what queries were being run, I thought. The product it used to be had that.

However, agree, if you need to capture the...

I'm not aware of any CE issues moving between versions greater than 2014. The optimization engine has changed at each version, and that could, in some edge cases, cause problems....

I don't think it's SQL Server 2019. I think it's SSMS. The latest release seems to be obscenely slow. It can take 2-3 minutes to launch on my laptop. I've...

The trick is in the name. People read common TABLE expression when they should read common table EXPRESSION. A CTE is not a table. It's just a query. There is...

I'll do a little editing on the answer.

wait - ???? you...

You kind of laid out my argument to a degree. "...except as source of information from others..."

If you want to be those "others" who are a source of information, that...

Yay! I got it right.

OK. That's odd. I'm not sure.

Do you have customizations in the model database? It's possible that if you have stuff there, it gets created when you create the new database,...