In this short post I’ll show you how to create database schema using dynamic SQL.
It’s easy, just take a look at the following code:
declare @SchemaName varchar(max)
set @SchemaName = ‘YOUR_SCHEMA_NAME’
if not exists (select 0 from sys.schemas where name=@SchemaName)
exec(‘create schema [‘+@SchemaName+‘]’)
The SQL Server 11.0 release (code named “Denali”) introduces a new data warehouse query acceleration feature based on a new type of index called the columnstore. Columnstore indexing is officially announced in SQL Server 2012. It is working based on xVelocity memory optimised technology and it improves data warehouse query performance significantly. Due to the fact that data warehousing, decision support systems and business intelligence applications are growing very quickly, we need to be able to read and process very large data sets quickly and accurately into useful information and knowledge. Columnstore index technology is especially appropriate for data warehousing data sets. It improves the common data warehousing queries’ performance significantly.
Continue reading Digging into SQL Server 2012 columnstore index