Skip to main content

Questions tagged [dedicated-sql-pool]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
48 views

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 ...
SOUser's user avatar
  • 21
0 votes
1 answer
671 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 ...
Fedeco's user avatar
  • 103
0 votes
1 answer
241 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 ...
xmlapi's user avatar
  • 11
1 vote
1 answer
145 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 ...
xmlapi's user avatar
  • 11
0 votes
1 answer
441 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 ...
xmlapi's user avatar
  • 11
5 votes
1 answer
1k 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] ...
András Váczi's user avatar
1 vote
3 answers
2k 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 ...
Mike's user avatar
  • 658