When managing SQL Server, partitioning is a strategy that can have significant impacts on your maintenance tasks. Partitioning involves dividing a database into parts or sections, which can be ...

Partitioning a table is a three step process ... the service principal that's part of the AD group that has been assigned as the admin for the SQL Server, needs to execute the create statements.