Displaying posts tagged with

“Table Partition”

Script to Partition in Existing Table in SQL Server

Partition in Existing Table in SQL Server. Step1 : Create Multiple File Group Database. Step2 : Create Simple Table with out partition. Step3 : Insert sample data into table with out partition. Currently we have created simple table without partition and now the step starts to create partition in existing table. Step4 : Create partition function. [...]

Script to get Table Partition information

Script to get Table Partition information. This script gives you Table Partition information with Partition Number, Scheme Name and Function Name. Regards, Nirav Gajjar