Data Science & Workshop - NYC
So, the new industry buzz word is Data Science. Are you a Data Scientist? Do you remember taking that in...
2016-08-23
1,603 reads
So, the new industry buzz word is Data Science. Are you a Data Scientist? Do you remember taking that in...
2016-08-23
1,603 reads
When the word comes around for elections to the PASS Board, are you one of those people who, even in...
2016-08-22
431 reads
Last week I got a call from one of our clients. They issued an ALTER TABLE command in order to...
2016-08-22
3,911 reads
In case you hadn’t noticed I’ve recently started looking at the cloud and what it entails. Well one of those...
2016-08-22
664 reads
One of the most popular questions on forums / SO etc is, “How can i find out who dropped a table,...
2016-08-30 (first published: 2016-08-22)
2,859 reads
In this module you will learn how to use the Aster Plot Power BI Custom Visual. The Aster Plot is...
2016-08-22
1,098 reads
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
791 reads
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
76 reads
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to...
2016-08-21
67 reads
I have been thinking quite a lot recently (ok not that much but my thinking has changed) about how to deploy dacpac's. In particular I am talking about how...
2016-08-21
24 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