Nested Display Folders in SSAS
Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is...
2016-03-16
1,119 reads
Recently it was announced that Power BI would now support the SSAS display folders in “exploration mode”. Exploration mode is...
2016-03-16
1,119 reads
If you are trying to install SQL Server 2016 RC0 – which I’m sure you are all doing looking at the...
2016-03-16
731 reads
Between attending SQL SKILLS immersion events, trying out for the PFE role at Microsoft I have managed to write some...
2016-03-16
195 reads
Multidimensional Cubes provide speed when it comes to retrieving aggregations that are important to business decisions. Being able to slice...
2016-03-16
580 reads
Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your purview. Then a small problem occurs: Index Cannot Be...
2016-03-16
36 reads
Working diligently as any good DBA might, you have established maintenance routines for each of the SQL Servers under your...
2016-03-16
545 reads
[read this post on Mr. Fox SQL blog] When it comes to enabling data compression in SQL Server I suspect most people don’t do a lot of testing as to the impacts of...
2016-03-15
21 reads
[read this post on Mr. Fox SQL blog]
When it comes to enabling data compression in SQL Server I suspect most people don’t do a...
2016-03-15
589 reads
This is a reminder to compete the annual Business Intelligence product survey conducted by BARC Research. I’ve been participating in...
2016-03-15
468 reads
I spend a decent amount of time on the road, traveling to events. Last year I think I spent 50...
2016-03-15
569 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