that column needs to be in the group by. That is what the error means

If you have 1000+ tables, and you want anytime a user inserts/updates/deletes, and you send alerts, how many is that? Can they even be processed?

Usually I hear this and I...

You're complaining a bit about your process with Microsoft's. My point is that any platform will have bugs and issues, and any patch can cause issues. Microsoft has done a...

Be good to have some sample data and sample results here, also what have you tried?

I'd say there is overhead for the OS with RAM, then add in a VM, and you've added more RAM overhead. SQL Server is very memory hungry, and you are...

https://twitter.com/ItzikBenGan/status/1620580822138118151

I don't know that I consider SQL Server 2019 a mess. There were some CU bugs, and the CU16 log format was a breaking, intentional change. I don't like how...

This essentially initializes the file so that only this backup is written to this file.

Recommended practice, back up each time to a new file.

If this feels complex use Ola's script: https://www.sqlservercentral.com/scripts/sql-server-backup-integrity-check-index-and-statistics-maintenance

This encrypt by default has been a pain, since lots connection strings need altering. thanks for posting the note.

Seems to work. Used two databases here:

Results are :

1 X

2 NULL

USE compare2
GO
CREATE TABLE TriggerTest (myid INT, mychar CHAR(1))
GO
CREATE TRIGGER tri_triggertest ON  dbo.TriggerTest FOR INSERT
AS
BEGIN
  ...

Indexing would be the only way I see to make this faster. Whether you use a CASE or Phil's solution, I wouldn't expect one to be appreciably faster.

I did an...

I'd wonder as well if there were some personal connection or perhaps some other non-business reason.

The only reason most people care about where you are in the cloud is governance....

Thanks, a data migration issue. I'll log this.

A related problem I see is that they know where the data is, but the same data is in so many different places there is no understanding of what...

• This reply was modified 3 years, 6 months ago by Steve Jones - SSC Editor.