Create a Date Dimension in Azure SQL Data Warehouse
Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...
2016-08-11 (first published: 2016-08-06)
2,467 reads
Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...
2016-08-11 (first published: 2016-08-06)
2,467 reads
Update: As Gerhard points out in the comments, switching to ORC files solves this issue nicely. It’s not human readable,...
2016-08-09 (first published: 2016-08-01)
2,158 reads
My friend and coworker Melissa Coates (aka @sqlchick) messaged me the other day to see if I could help with a...
2016-07-28
815 reads
This is post #2 of my BimlScript – Get to Know Your Code Nuggets series. To learn about text nuggets, see my...
2016-07-01
486 reads
In BimlScript, we embed nuggets of C# or VB code into our Biml (XML) in order to replace variables and...
2016-06-30
954 reads
Update: The ability to change the color of a KPI was delivered in August 2016!
Color blindness, or color vision deficiency (CVD)...
2016-04-23
610 reads
I like to think I’m proficient at writing DAX and building SSAS tabular models. I enjoy a good challenge and...
2016-03-01
474 reads
This week I was asked to create a matrix in a Power BI report that looks like this:
Matrix with Values on...
2016-01-09
1,323 reads
I encountered a situation on my last SSIS project in which I needed to be able to populate the query in lookup...
2015-12-29
853 reads
In my previous post, I provided the design pattern and Biml for a pure Type 2 Slowly Changing Dimension (SCD). When...
2015-12-27
625 reads
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers