10 DAX Calculations for your Tabular or Power Pivot Model (Part 2)
This is part two of my 10 DAX Calculations blog series. In this series I’ve blogged ten different DAX calculations...
2015-10-21
489 reads
This is part two of my 10 DAX Calculations blog series. In this series I’ve blogged ten different DAX calculations...
2015-10-21
489 reads
This is part two of my 10 DAX Calculations blog series. In this series I’ve blogged ten different DAX calculations...
2015-11-02 (first published: 2015-10-21)
2,428 reads
I recently recorded an interview with PernixData where he discusses some of the largest challenges with virtualized databases, and talks about...
2015-10-30 (first published: 2015-10-21)
988 reads
I make a habit of using the latest version of SSMS even if I’m not working with the latest version...
2015-10-29 (first published: 2015-10-21)
1,713 reads
In this article I will be taking you into the world of the pair_matching target. The pair_matching target should connote that this target works on matching like events into...
2015-10-21
18 reads
I just covered the topic of matching events from definition on down through highlighting a common use for this type...
2015-10-21
775 reads
It seems to be the most basic thing but this post is specifically to those who have just started or...
2015-10-20
345 reads
It seems to be the most basic thing but this post is specifically to those who have just started or...
2015-10-29 (first published: 2015-10-20)
2,765 reads
Thanks for joining Anthony Martin (@SQLMartini) and I at the Boston BI User Group Meeting in October. During the session,...
2015-10-28 (first published: 2015-10-20)
2,632 reads
There is a particularly irritating and persistent belief that indexes (usually it’s the clustered that gets picked on) are always...
2015-10-26 (first published: 2015-10-20)
2,847 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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