what is the difference between sql server standard and web edition?
Web is limited to 4 sockets with a max of 16 cores vs standard which is 4 sockets with a max of 24 cores. Web has no failover cluster instance or availability group support unlike standard which has some limited support. No row level security or data masking in web. It is in standard.