What strategies do you use for partitioning and indexing in Microsoft SQL Server to improve performance?