Questions tagged [dedicated-sql-pool]
The dedicated-sql-pool tag has no usage guidance.
7
questions
0
votes
1
answer
334
views
Dedicated SQL Pool In Azure - Cannot use System Views to calculate size for tables
I know that it's a repeated question but I've tried all solution and workaround suggested from every possible question present on stackoverflow.com
I have inherited a dedicated SQL Pool with a SQL ...
- 103
0
votes
0
answers
157
views
Copy data from Data Lakes to Dedicated SQL Pool - Data Type overflow error
We have a synapse pipeline that copies data from Data Lakes (Parquet Files) to the Dedicated SQL Pool in Azure. The problem is that some of the Copy Data tasks fail with a "Arithmetic overflow ...
- 11
0
votes
1
answer
195
views
Hash, Replication, and Round Robin Distributions - Need more clarification
I will give a few examples of the tables we have:
Table1 - Most queries are State Code and Year, has about 1000 rows, will grow by 1000 rows a year, used Round Robin
Table2 - Most queries are by ...
- 11
1
vote
1
answer
105
views
Azure Dedicated SQL Pool - How to checksum a table?
We're moving all our on premise tables into the azure dedicated sql pool. We're using synapse workspace pipelines to import the data into the dedicated pool.
Is there a way to checksum a table to ...
- 11
0
votes
1
answer
323
views
Azure Dedicated SQL pool - group has db_datareader access but cannot login
We have created Test AD Group and they should have readonly access to the database (schemas and tables, views) in the Azure SQL dedicated pool.
Our DBA team did it but the users in the Test AD Group ...
- 11
5
votes
1
answer
706
views
User can drop table from a schema, but cannot create one
In an Azure Synapse dedicated SQL pool I have the following setup:
-- a custom DB role to manage privileges
CREATE ROLE [owner];
-- there is a schema owned by this role
CREATE SCHEMA [myschema] ...
- 31k
1
vote
3
answers
1k
views
What are the limitations in Synapse Analytics compared to normal SQL Server?
I'm keen to get a list of the feature limitations or suprises when using Synapse Analytics (a.k.a. Dedicated SQL Pool, used to be known as SQL DW / SQL Data Warehouse) compared to using normal SQL ...
- 628