User Profile
JovanPop
Joined 7 years ago
User Widgets
Recent Discussions
Re: Serverless SQL Pool - Reading from Parquet - VARCHAR with UTF8 Collation - Data Getting Truncated
ea25 could you try to increase VARCHAR(60) to VARCHAR(600) and see would it be truncated? The number in VARCHAR is size in bytes and not size in characters so some special characters might occupy more than 1 byte per char.2.2KViews0likes0Comments
Recent Blog Articles
Best practices for integrating serverless SQL pool with Cosmos DB Analytical store via Synapse Link
In this post you will find the tips and tricks that would help you to optimize performance of your serverless SQL pool that is reading data from the Cosmos DB analytical storage using the Synapse Lin...9.4KViews5likes0CommentsOptimize the types of the columns to improve performance in serverless SQL pool databases
Minimization for column sizes is one of the most important schema optimizations in serverless SQL pools. In this article, you will learn why is type minimization important and what would be impacted....6.2KViews2likes1CommentImprove performance of Parquet external tables using new native technology in dedicated SQL pools
The native external tables in the dedicated SQL pools in Azure Synapse analytics are the new technology that will boost performance of your queries that use the external tables on top of Parquet file...12KViews7likes3Comments