Yesterday I covered the basics of partitioned views. I also mentioned there were some gotchas when it comes to modifying the data in those partitioned views. I’d like to go into more detail about that today. The first big gotcha on updating data in a partitioned view is making sure you can update the data…
Read More Modifying Data in Partitioned ViewsLast week I covered partitioning. I explained how you could set up filegroups in your database, and then split data from a single table or index across those filegroups. That way you can reduce blocking in your objects by physically separating the data into parts. I even covered how you could use partitioning to speed…
Read More Partitioned ViewsOK, 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…
Read More Partitioning: MERGE, SPLIT, and SWITCH