Partitioning: MERGE, SPLIT, and SWITCH
OK, you know how to set up partitioning for a table and an index, and now you think you’ve solved your deadlocking, and your I/O issues forever, right? Hardly. Once you’ve been in SQL long enough you learn that no answer is forever. Inevitably you’ll have to revisit your old queries and see if their [...]





