Query Curious Data Engineering blog by Maria Zakourdaev

About the author

I am a Data Platform Microsoft MVP and a technology expert with more than 20 years of experience, a community leader with a profound knowledge of Microsoft products and services, while also being able to bring together diverse platforms, products, and solutions, to solve real-world problems. I have a hands-on experience managing various data management technologies in Azure, AWS and Google public cloud platforms, including SQL Server, Azure CosmosDB, AWS DynamoDB, MemSQL, MySQL, Postgres,Snowflake, Redis, Clickhouse and many more. You can follow me on LinkedIN https://www.linkedin.com/in/redheaddba/

Tag: partition_id

Changing partition_id in SQL Server partition tables

When switching partition in or out, partition_ids are changing for both source and destination, even if destination is a regular table. At the beginning I thought that new id's are being issured but it appears that SQL Server simply…

Aug 19, 2009

Statistics are saved on table level and not on partition level (both SQL 2005 & 2008

Currently table statistics and histograms are saved per table and not per table partition. Many environments that i see experience real performance degradation when migrating from view partitions to native partitions because, thanks to…

Nov 02, 2008