Tag Archives: partitioning

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

Table Partitioning Implementation with advanced scenarios (Part 1)

This gallery contains 1 photo.

HI …. Today I will write in very wonderful topic SQL Server Partitioning and my post will be as Repository for the beginner and for Expert because I will cover the main and most important point and the most cases … 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