Buzzword Bingo
Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS....
2017-06-13
984 reads
Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS....
2017-06-13
984 reads
Thanks to Grant for hosting this month’s T-SQL Tuesday found (http://www.scarydba.com/2017/06/06/t-sql-tuesday-091-databases-devops/) where it is a chance to share our DevOps...
2017-06-13
566 reads
A quick blog post on finding where the trend line is hiding in Power BI Desktop. Docs will state it...
2017-06-20 (first published: 2017-06-13)
10,599 reads
In this module you will learn how to use the Enlighten World Flag Slicer Custom Visual. The Enlighten World Flag...
2017-06-20 (first published: 2017-06-13)
2,044 reads
Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it individually. In...
2017-06-13
1,697 reads
Data Science in DTC Tomorrow - Tuesday June 13, 2017 to be precise – is the initial meeting of a new meetup...
2017-06-12
176 reads
The Wikipedia Graph Database page has the following definition…
In computing, a graph database is a database that uses graph structures...
2017-06-12
116 reads
Looking forward to combining a work trip with a SQLSaturday trip to Houston this week!
Will be happy to see the...
2017-06-12
384 reads
Obviously the big news of the day is the announcement for general availability of Power BI Premium! And if you...
2017-06-12
213 reads
Obviously the big news of the day is the announcement for general availability of Power BI Premium! And if you...
2017-06-12
651 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