MS-SQL Server - Sharding & Character

Sharding & Character

Divide a data store into a set of horizontal partitions or shards...

Related article...

https://learn.microsoft.com/en-us/azure/architecture/patterns/sharding

Again calling 'Character' here is nothing but providing correct datatype with maximum required character limit (while writing procedure) would give significant performance impact over the application.

https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver16

Additionally,

SQL Server ID Jump 1000 issue fixed in SQL Server 2019 ?

https://learn.microsoft.com/en-us/answers/questions/517365/sql-server-id-jump-1000-issue-fixed-in-sql-server

Proof of concept connecting to SQL using pyodbc

https://learn.microsoft.com/en-us/sql/connect/python/pyodbc/step-3-proof-of-concept-connecting-to-sql-using-pyodbc?view=sql-server-ver16

Best Regards

T. Amit Vaid S.