Question : I’m trying to change a column data type from datetime2 to datetimeoffset. I have db owner permissions. Whenever […]
Tag: azure-sql-data-warehouse
sys.partitions row count is badly wrong – how to correct this?
Question : Querying sys.partitions can return an approximate row count for a table. I’ve noticed that this is returning the […]
How to prevent Dropping of tables but allow Creating of them, within a Schema
Question : Is it possible to, within a specific Schema, allow a user to create a table, and select from […]
Why does my columnstore index not fill the entire rowgroup?
Question : I’m using [vColumnstoreDensity] to monitor the health of my columnstore indexes. I’ve noticed that I’ve got one index […]
What cases benefit from the Reduce, Replicate, and Redistribute join hints?
Question : The From Clause Documentation starting with SQL Server 2008 briefly mention 3 join hints and their basic mechanisms: […]
How to index cube style queries with changing aggrigations
Question : I’ve got a query that emulates the CUBE function. This is many different aggregations unioned together. select x,y,z, […]
How many rows can SQL Server process in a single INSERT statement into a table?
Question : To illustrate my question, the following is a query detecting order’s id which have not been inserted in […]
How to index cube style queries with changing aggrigations
Question : I’ve got a query that emulates the CUBE function. This is many different aggregations unioned together. select x,y,z, […]
How to achive a many to one merge join in Azure Data Warehouse
Question : I have a merge join in azure data warehouse. My estimated execution plan currently shows it as a […]
Copy real time data from Azure SQL into Azure Data Warehouse
Question : I would like to copy our data from Azure SQL (OLTP) into Azure Datawarehouse. I want the path […]