Azure SQL DB MAXSIZE – what can I do with that?

Information:  Azure SQL DB max size is limited by the pricing tier for each DB. for instance Basic is limited by 2GB, Standard by 250GB, and Premium by 500GB per database. you can also set your own limit while it’s lower or equal to the level max size and if this is in the list…


Azure SQL DW – column name is case sensitive with hash distribution

Symptoms:  When using PolyBase bulk operation to load data into Azure SQL DW (Data Warehouse)  and using the HASH distribution you may receive this error message: [OLE DB Destination [471]]: The source and target columns must be in the same order in the INSERT BULK statement An OLE DB record is available.  Source: “Microsoft SQL…


Does Azure SQL DB support automatic indexed views?

Are indexed views used automatically in SQL Azure without “WITH (NOEXPAND)”?How does it work?and How the query optimizer decides to use it or not ? The query optimizer uses indexed views to speed up the query execution. Which means SQL Server’s query optimizer realizes the precomputed sums of all the Quantity values for each value are…