Microsoft Data Insights Summit Day 2 Recap: Timeline Storyteller, Future of Power BI Desktop, and Freakonomics
The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of...
2017-06-15
253 reads
The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of...
2017-06-15
253 reads
The theme of day 2 of the Microsoft Data Insights Summit was sessions, sessions, sessions! There were a ton of...
2017-06-27 (first published: 2017-06-15)
2,114 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-06-15
1,155 reads
Thank you to everyone who participated in T-SQL Tuesday #091 which was on databases and DevOps. As I anticipated, this...
2017-06-23 (first published: 2017-06-15)
1,726 reads
I ran into an interesting error the other day while doing a partition switch.
Partition switch failed because : column ‘xyz’...
2017-06-26 (first published: 2017-06-15)
3,191 reads
The Data Science Virtual Machine (DSVM) is a customized VM image on Microsoft’s Azure cloud built specifically for doing data...
2017-06-23 (first published: 2017-06-14)
2,463 reads
My First DELETE Statement Here are the links to the previous posts in this series: My First SELECT Statement My...
2017-06-14
160 reads
Most traditional ETL processes perform their loads using three distinct and serial processes: extraction, followed by transformation, and finally a...
2017-06-14
963 reads
I have a SQL Server that is constantly producing “dump” files (with a MDMP File type), these are named SQLDumpxxxx...
2017-06-14
640 reads
A question that regularly comes up when I talk about containers is, “can you specify where the containers/images live on...
2017-06-22 (first published: 2017-06-14)
1,390 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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...
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