Working with Tables in Azure SQL Data Warehouse
In this next installment of our series on Azure SQL Data Warehouse, we'll look at tables and the options for how we decide to create them for optimum performance.
2017-04-18
2,100 reads
In this next installment of our series on Azure SQL Data Warehouse, we'll look at tables and the options for how we decide to create them for optimum performance.
2017-04-18
2,100 reads
Learn how you can create an Azure SQL Warehouse database quickly and easily.
2017-04-14
933 reads
Learn how to scale an Azure SQL Datawarehouse up or down, and how to pause it when not in use.
2017-04-10
458 reads
Learn about Azure SQL Data Warehouse and how to get started.
2017-04-05
1,010 reads
Chris Testa-O'Neil on the origins of SQL Bits and the joys of community events.
2015-02-10
144 reads
By Steve Jones
I needed to test a striped backup, so I decided to ask the AI’s...
By gbargsley
In SQL Server environments where transactional replication runs alongside Always On Availability Groups (AGs),...
Disable the sa login in SQL Server (and sleep better)If you run SQL Server...
Comments posted to this topic are about the item Create an HTML Report on...
The SQLPS.exe file has gone AWOL on 2 of my 4 SQL servers, ie,...
Comments posted to this topic are about the item Be Wary of Data
You have a table [dbo].[orders] without a Clustered Index (Heap). The table does not have any other nonclustered indexes! You rund the following command in Read Committed Isolation Level:
SELECTo_orderdate, o_orderkey, o_custkey, o_storekey FROMdbo.orders WHEREo_orderkey = 3877;