Demystifying the Type 2 Slowly Changing Dimension with Biml
Most data warehouses have at least a couple of Type 2 Slowly Changing Dimensions. We use them to keep history...
2015-12-21
1,016 reads
Most data warehouses have at least a couple of Type 2 Slowly Changing Dimensions. We use them to keep history...
2015-12-21
1,016 reads
This is one the articles in the series of step by step SSIS tutorial. In this post, we are going...
2015-12-20
851 reads
I saw the post from Steve Jones about the Advent of Code contest and decided to take a look. The first...
2015-12-18
671 reads
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2015-12-18
324 reads
The new Star Wars film opens today, and while I won’t see it then, perhaps I’ll get to it early...
2015-12-18
634 reads
The hardest presentations I’ve ever given in my life were not to large audiences or in big rooms. They weren’t...
2015-12-18
460 reads
In last post tip #122, We discussed Merge transformation. Now in this tip, we are going to discuss Merge Join....
2015-12-31 (first published: 2015-12-18)
2,577 reads
Poor storage performance continues to be the largest pain point with enterprise Database Administrators in today’s virtual world. However, it...
2015-12-17
1,091 reads
I recently was tasked with this ticket:
Please add new login Domain\Bob to server MyServer. Grant the login the same permissions...
2015-12-17
2,196 reads
Have you ever seen the error below in your SQL Server log shortly after startup? You’ll actually see two of...
2015-12-29 (first published: 2015-12-17)
1,582 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