79811749

Date: 2025-11-06 20:37:10
Score: 1
Natty:
Report link

ALTER TABLE ... SWITCH on its own does not require Enterprise Edition (neither has partitioning in general, since 2016 SP1). https://kendralittle.com/2017/01/19/why-you-should-switch-in-staging-tables-instead-of-renaming/ & https://kendralittle.com/course/tuning-problem-queries-in-table-partitioning/ Also see here for some other options and info: https://stackoverflow.com/a/69224284

Reasons:
  • Blacklisted phrase (1): stackoverflow
  • Probably link only (1):
  • Low length (1):
  • Has code block (-0.5):
  • Single line (0.5):
  • High reputation (-2):
Posted by: Aaron Bertrand