SQL Server Big Data Clusters by Benjamin Weissman & Enrico van de Laar

Author:Benjamin Weissman & Enrico van de Laar
Language: eng
Format: epub
ISBN: 9781484251102
Publisher: Apress

Listing 5-19Store data from CSV in temp tables instead of direct queries

This improves performance tremendously without wasting too many system resources as the large dataset stays within the CSV.

One of the biggest challenges in such an environment is finding a good trade-off between data redundancy and performance.

Accessing Data in an Azure Blob Storage

If you are storing data in an Azure Blob Storage, there is no need (apart from maybe network latency) to copy that data into your SqlStoragePool. You can also access a Blob Storage by defining it as an external data source (Listing 5-20).CREATE EXTERNAL DATA SOURCE AzureStorage with (

TYPE = HADOOP,

LOCATION ='wasbs://<blob_container_name>@<azure_storage_account_name>.blob.core.windows.net',

CREDENTIAL = AzureStorageCredential

);

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.