Power BI Custom Visuals Class (Module 59 – Drilldown Cartogram)
In this module you will learn how to use the Drilldown Cartogram Custom Visual. The Drilldown Cartogram is a map...
2017-07-18 (first published: 2017-07-11)
2,022 reads
In this module you will learn how to use the Drilldown Cartogram Custom Visual. The Drilldown Cartogram is a map...
2017-07-18 (first published: 2017-07-11)
2,022 reads
This month’s T-SQL Tuesday is hosted by Raul Gonzalez and he’s asked everyone to share things we might be a bit embarrassed about:
For this month, I want you...
2017-07-11
23 reads
On July 12th 6.30 PM PST, I will be presenting “SQL Implementations On Containers” @ at San Francisco data platform user...
2017-07-10
477 reads
You may have heard, or read, that you should not mix VARCHAR and NVARCHAR datatypes, especially when one of them...
2017-07-10
5,321 reads
Hello Dear Reader! This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing movie with a fantastic cast. Both of us are...
2017-07-10
17 reads
Hello Dear Reader! This past Thursday night I took my son Zachary to see Spider-Man Homecoming, it was an amazing...
2017-07-10
374 reads
The performance of a database is the most challenging and critical part of database optimization. The challenge every DBA faces...
2017-07-10
472 reads
Have you heard of these following terms and/or phrases?
Database Continuous DeliveryDatabase Lifecycle Management (DLM)DevOps[Insert other buzzword bingo entry here]You probably...
2017-07-10
128 reads
Have you heard of these following terms and/or phrases?
Database Continuous DeliveryDatabase Lifecycle Management (DLM)DevOps[Insert other buzzword bingo entry here]You probably...
2017-07-10
286 reads
In the previous post in this series, I addressed how to use an on-premises instance of SSIS to move data...
2017-07-10
1,009 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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