Latest news

Lorem ipsum dolor sit amet, at mei dolore tritani repudiandae. In his nemore temporibus consequuntur, vim ad prima vivendum consetetur.

SELECTCONVERT(DECIMAL(12,3),SUM(user_object_reserved_page_count) / 128.)AS [User Objects (MB)],CONVERT(DECIMAL(12,3),SUM(internal_object_reserved_page_count) / 128.) AS [Internal Objects (MB)],CONVERT(DECIMAL(12,3),SUM(version_store_reserved_page_count) / 128.) AS [Version Store (MB)],CONVERT(DECIMAL(12,3),SUM(unallocated_extent_page_count) / 128.) […]
Steps are: Suspend your database to close data movementsChange Readable secondary Nodes to “NO”Move Your DatafilesAlter database <database_name> MODIFY FILE […]
The optimize for ad hoc workloads option is used to improve the efficiency of the plan cache for workloads that contain many […]