How to Automate Processing of Azure Analysis Services Models
I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache...
2017-06-21
553 reads
I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache...
2017-06-21
553 reads
I’ve been working on a proof of concept for a customer that involved using Azure Analysis Services as a cache...
2017-06-21
2,611 reads
In 2017, there’s no excuse not to have at least a testing environment, and preferably a development environment as well,...
2017-06-21
146 reads
Target. Home Depot. NASA. U.S. Army. Anthem. Wall Street Journal. MarketWired. Ashley Madison. What do they all have in common?...
2017-06-21
840 reads
Microsoft announced a new program last year to help you understand the skills that a Data Scientist needs in their...
2017-06-21
484 reads
I have been working at Microsoft now for 3 years and 4 months (side note: it’s by far the best...
2017-06-21
857 reads
My last post talked about 9002 errors and how they *might* be corruption.
Recently I moved up to the next consecutive...
2017-06-21
2,039 reads
If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run...
2017-06-21
665 reads
Two years running, I will be presenting at SQL Saturday Indy and SQL Saturday Louisville this year again! Come see my SQL Server 2017 (Linux and Beyond) and Stretch...
2017-06-21
30 reads
I wanted to import the million song dataset in SQL Server on Linux. There’s a github repo that has the...
2017-06-30 (first published: 2017-06-21)
2,958 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