SQL Server Data Partitioning by Vijay Reddy

Просмотров 30 тыс.

% 361

Learn about the largest online learning event on Azure Data, Analytics & AI covering 30+ technologies including SQL Server, Power BI, MS AI stack, Azure Data stack & Advanced Analytics stack: www.DataPlatformVirtualSummit.com
Follow us on Twitter
TheDataGeeks
SQLServerGeeks
DataAISummit
SQLMaestros
A_Bansal
.
.
(Get new content delivered in your inbox: bit.ly/SSGRSS)
Please note that this a recorded webinar. It was recorded during live presentation.
In this webinar, you will learn about SQL Server Data Partitioning. Webinar resources including presentation, demo files, code snippets and more learning material is available on www.dataplatformgeeks.com/ (Join for free and access all the resources)
As a DPG member, you have free access to all our learning resources like videos, Hands-On-Labs & past event resources.
Suggest us topics that you wish to learn through our webinars: www.dataplatformgeeks.com/dpg-suggest-topics/
Connect with DataPlatformGeeks: www.dataplatformgeeks.com/
SQLServerGeeks
SQLServerGeeks
Email us: admin@DataPlatformGeeks.com
Have technical questions? Join the largest SQL/Data group on FaceBook - groups/thesqlgeeks/
LinkedIn Group: www.linkedin.com/groups/6753546
DataPlatformGeeks (DPG) Community
Join the fastest growing community of data & analytics professionals
Why Join DPG? www.dataplatformgeeks.com/
-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
-www.dataplatformgeeks.com/
Data Platform Summit 2019 Registration is now Open
DPS 2019 was officially launched on Feb 2 in Bengaluru. 3 days of pre-con on August on 19, 20 & 21. Conference on August 22, 23 & 24. To learn more visit: www.dps10.com/
Check out Data Platform Summit 2018 success: www.dataplatformgeeks.com/dps2018/
A word from our knowledge Partners:
SQLMaestros Master Classes
Wish to Attend Full-Day, Deep-Dive Training? SQLMaestros Master Classes are announced. Classes on SQL Server, SSRS, Power BI, SSIS, DevOps, Machine Learning, R, Python & Artificial Intelligence. www.sqlmaestros.com/
SQLMaestros Video Courses
Amit Bansal’s popular SQL Performance Tuning course is now going live in video format. sqlmaestros.com/sql-server-videos-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.
hols.SQLMaestros.com
Email holsales@SQLMaestros.com
SQLMaestros Learning Kits
The kit comprises of PowerPoint presentations, lab manuals, workbook & instructor demos & notes. The kit is based on Amit Bansal’s Performance Tuning Master Class. sqlmaestros.com/sql-server-courseware/
SQL Server Health Check
If your SQL Server deployments are not performing good or if you have seen early signs of performance degradation, SQLMaestros can help you with a thorough health check. sqlmaestros.com/sql-server-health-check/
Connect with the founder of DataPlatformGeeks/SQLServerGeeks
Follow on Twitter: A_Bansal
Follow on FaceBook at amit.r.bansal
Follow on LinkedIN: www.linkedin.com/in/amitbansal2010
Facebook Page: AmitRSBansal

Наука

Опубликовано:

22 фев 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 23

@rohidaskumbharkar7277 4 года назад

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

@saurabh7629 3 года назад

thanks for sharing such informative sql tutorial videos.

@premkuruva5359 3 года назад

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

@surajviz9272 2 года назад

Can we get the SQL used in the videos please ?

@samirkumar6180 3 года назад

Nicely described.. Thanks

@ajay_jangra 4 года назад

informative, thanks!

@shanmuga_12 4 года назад

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

@vijayreddyyeruva6156 4 года назад

No. You will have to partition the respective child or reference tables as well and make sure the data references are intact across partitions on both parent and child tables to avoid integrity issues later when you switch out data from parent tables.

@anilalakshmanan3700 3 года назад

How difficult to manage daily partitions

@WafaPRO 3 года назад

Amazing

@bhagyashrishawanti1468 3 года назад

Needed partition view detail scripts

@dumbdba2463 2 года назад

Stats at 06:40

@prabhakarbts4003 4 года назад

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

@dumbdba2463 2 года назад

You need to read BOL on how partitioning works. No, partitioning a table won't affect the other tables.

@beautifullife5714 4 года назад

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

@vijayreddyyeruva6156 4 года назад

Yes, since data is divided into small portions.

@dumbdba2463 2 года назад

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.

@nismokid 2 года назад

Sidd DBA, I disagree with your statement. If the primary goal was just for ease of data management, you don’t need to partition. You could simply denormalize table and eliminate joins. The idea behind partitioning IS TO improve query performance and you do so by splitting larger data into multiple file groups to reduce the number of rows a query has to process. FYI, it may serve you best to further your studies before throwing an uneducated statement. :)

@dumbdba2463 2 года назад

@@nismokid I'd suggest you to do a bit research before posting generic statements. The primary purpose of Table partitioning is not improving query performance. Better you start reading and doing research.

@piyushpatil1745 4 года назад

Can I get script of this session for reference

@SQLServerGeeks 4 года назад

Sure. Please download it from here. www.dataplatformgeeks.com/resources/

@senp1000 4 года назад

Not able to download the scripts. Piyush were you able to?

@MrDoctorFog 3 года назад

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.