Use this option to recompile stored procedures or triggers that are dependencies for one or more tables.
To compile dependencies
Right-click one or more tables, and select Tasks | Compile Dependencies.
You can delete all data from a table using this feature.
Caution: You cannot rollback changes if you truncate data.
To truncate a table
Right-click one or more tables, and select Tasks | Truncate Tables.
Partitioning a table arranges the data into smaller more manageable pieces. The CPU can perform operations on more than one partition simultaneously, which improves performance. A very large database performs best if the partitions use multiple disks, separate filegroups, and preferably multiple CPUs.
Note: This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.
To partition a table
Select Tables from the Databases node in the Object Explorer.
Complete the wizard.
Tips:
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Conditions d’utilisation Confidentialité Cookie Preference Center