Tag Archives: distributing

SQL Server 2014 Health check DMV queries Day 2

This gallery contains 1 photo.

Hi guys in the Previous post i explained How we can get the SQL Server instance version and How we can know the installed date for SQL Server instance put today is DAY 2 and i will show new DMV in … Continue reading

Gallery | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Distributing and Partitioning Data in SQL Server 2008

This gallery contains 1 photo.

A Partition Function defines the set of boundary points for which data will be partitioned, otherwise a partition scheme provide an alternate definition for storage. You define a partition scheme to encompass one or more file groups. The final step … Continue reading

Gallery | Tagged , , , , , | Leave a comment