SQLTeam.com | Weblogs | Forums

Sql 2012 table partition



I have a table partition, when each partition has its own filegroup-one file.
before the insert statement , how i can know where the row is going to be site ?

what is the meaning of "next use" in alter scheme ?



When you can identify a row or set of rows already in the table. Please try this sample query.


  FROM dbo.table
  WHERE <clause to identify rows>;

To know more about partitioning please go this one it may be helpful to you. https://msdn.microsoft.com/en-us/library/ms188071.aspx