SQL Server Data Partitioning by Vijay Reddy

Follow us on Twitter
.
.

Please note that this a recorded webinar. It was recorded during live presentation.

As a DPG member, you have free access to all our learning resources like videos, Hands-On-Labs & past event resources.



DataPlatformGeeks (DPG) Community
Join the fastest growing community of data & analytics professionals

-Attend all events hosted by DPG, including SQLMaestros Special Events
-Get access to free videos, labs, magazines and host of learning resources
-Download all events & conference material
-Learn new skills. Sharpen existing skills
-Be part of Asia’s Largest Data/Analytics Community
-Opportunity to be a regional mentor & speaker at our events
-Immense technical & professional development

Data Platform Summit 2019 Registration is now Open

A word from our knowledge Partners:

SQLMaestros Master Classes

SQLMaestros Video Courses

SQLMaestros Hands-On-Labs
Want to practice SQL, Azure & BI concepts, step-by-step with exercises, screenshots, instructions & explanations? Get access to 100+ labs covering the entire Microsoft Data Platform stack. Try SQLMaestros Hands-On-Labs – the new way of practical, self-paced learning. Anytime. Anywhere.

SQLMaestros Learning Kits
SQL Server Health Check

Connect with the founder of DataPlatformGeeks/SQLServerGeeks

[saurabh]

thanks for sharing such informative sql tutorial videos.

[rohidaskumbharkar]

Displays the first screen introduction in the monthly partition, but then the example in the ID column ?

[surajviz]

Can we get the SQL used in the videos please ?

[dumbdba]

FYI, the primary goal of partitioning is ease of data management not performance. Though it may improve performance it is not meant to be used as a performance tuning technique.

[premkuruva]

Can anyone share dynamic partition script.
We are planning to partition by month.
Always 3 upcoming files and file groups should be create.

[beautifullife]

Hi sir, I have around 50 million record's will it update fast on partition table

[anilalakshmanan]

How difficult to manage daily partitions

[prabhakarbts]

I have 3 tables with ralational A to B to C and A B having datetime column but C having only Interger column, If i want to create Partioning how can do on these 3 tables. If do on A table it will reflcet in all the tables with partitoning

[shanmuga_]

Hi can anyone tell me that partitioning a parent table will automatically partition the child or reference table

[piyushpatil]

Can I get script of this session for reference

[MrDoctorFog]

The tutorial is not bad, but to be honest I started to stop to watch because you take too much time to explain basic concepts, and because of this my attention went down a bit. You should be more straight-forward with your video man. Take it as an humble suggestion.