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.
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. :)
@@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.
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
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.
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.
Stats at 06:40
Displays the first screen introduction in the monthly partition, but then the example in the ID column ?
Can we get the SQL used in the videos please ?
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.
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. :)
@@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.
Can anyone share dynamic partition script.
We are planning to partition by month.
Always 3 upcoming files and file groups should be create.
thanks for sharing such informative sql tutorial videos.
How difficult to manage daily partitions
Hi sir, I have around 50 million record's will it update fast on partition table
Yes, since data is divided into small portions.
Needed partition view detail scripts
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
You need to read BOL on how partitioning works. No, partitioning a table won't affect the other tables.
Nicely described.. Thanks
Hi can anyone tell me that partitioning a parent table will automatically partition the child or reference table
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.
informative, thanks!
Can I get script of this session for reference
Sure. Please download it from here. www.dataplatformgeeks.com/resources/
Not able to download the scripts. Piyush were you able to?
Amazing
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.