Dynamically Changing Shapes in Power BI – Alternatives
NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used...
2017-02-16 (first published: 2017-02-08)
1,720 reads
NOTE: the DAX presented in this blog post is written in my locale (nl-BE). This means that semicolons are used...
2017-02-16 (first published: 2017-02-08)
1,720 reads
I’ve been playing around with SQL containers on Windows Sever 2016 a lot recently and well, building empty SQL containers...
2017-02-14 (first published: 2017-02-08)
3,352 reads
Follow my last post which can be found here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/), we discussed about replacing table variable by memory optimized table, this...
2017-02-13 (first published: 2017-02-08)
8,223 reads
This is the third article in my series about learning how to use SQL Server 2016's new JSON functions. If you haven't already, you can read Part 1?—?Parsing JSON...
2017-02-07
37 reads
Ensuring and maintaining team productivity practices is important for any organization, especially a small and growing team. The biggest part...
2017-02-07
452 reads
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late and I need to find a better way to...
2017-02-07
51 reads
It’s Tuesday and time to get Monday’s weekly blog and twitter round-up for last week out the door. It’s late...
2017-02-07
1,001 reads
I love the questions I get while I’m presenting because they force me to think and learn. The question in...
2017-02-14 (first published: 2017-02-07)
1,523 reads
How often is cost the deciding factor in the case of Windows vs Linux? And what if cost wasn’t a...
2017-02-07
406 reads
UPDATE: I also published a blog post using a DAX only approach. Check it out here.
Recently someone had a question...
2017-02-13 (first published: 2017-02-07)
3,006 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