Questions tagged [dedicated-sql-pool]
7 questions
5
votes
1 answer
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] AUTHORIZATION [owner];
-- an Azure AD group to allow…
András Váczi
- 31,778
- 13
- 102
- 151
1
vote
1 answer
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 compare it against on premise table to make sure…
xmlapi
- 11
- 1
1
vote
3 answers
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 Server. Basically the things that you would expect…
Mike
- 692
- 4
- 15
0
votes
1 answer
Divide by Zero error in Materialized Views in Azure Synapse Dedicated SQL Pool
I have a materialized view in Azure synapse Analytics dedicated sql pool which has a calculate column X / denominator.
When I select the view select * from myview it does not give me divide by zero error.
But when I select
Select * from myview where…
SOUser
- 31
- 6
0
votes
1 answer
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 Server version 2012.0.2000.8 on which there are…
Fedeco
- 103
- 3
0
votes
1 answer
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 State Code, Year, Column 1 (String), has about 1000…
xmlapi
- 11
- 1
0
votes
1 answer
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 cannot login until they select the database as the…
xmlapi
- 11
- 1