All Questions

Filter by
Sorted by
Tagged with
5
votes
2answers
1k views

How many rows can SQL Server process in a single INSERT statement into a table?

To illustrate my question, the following is a query detecting order's id which have not been inserted in a data warehouse and inserts them: With NewOrders As ( Select OrderID From Orders ...
3
votes
1answer
385 views

Revision Tracking & Source Control for Azure SQL Data Warehouse

What is a good approaching for tracking incremental changes to database tables, stored procedures, etc for Azure SQL Data Warehouse? I am in the process of moving a large database over to Azure SQL ...
4
votes
2answers
757 views

How Can I Measure How long a query takes on Azure SQL Data Warehouse

In traditional SQL Server I can get CPU and Elapsed Time by setting the following set statistics time on When I try that on Azure SQL Data Warehouse I get the following error Msg 103010, Level 16, ...