Why use a data lake?
Previously I covered what a data lake is (including the Azure Data Lake and enhancements), and now I wanted to touch...
2015-12-29
3,350 reads
Previously I covered what a data lake is (including the Azure Data Lake and enhancements), and now I wanted to touch...
2015-12-29
3,350 reads
Maybe you’re new to SQL Server or maybe you’re just expanding into performance tuning a little more. Query tuning can...
2015-12-29
504 reads
It’s the time of the year again: the obligatory “how was the past year” blog post, combined with “what do...
2015-12-29
799 reads
I encountered a situation on my last SSIS project in which I needed to be able to populate the query in lookup...
2015-12-29
853 reads
Self-service data modeling tools like Power BI Desktop, Power Pivot and SSAS Tabular promote the advantage of using data from...
2015-12-29
1,071 reads
An execution plan is basically a road map that graphically or textually shows the data retrieval methods chosen by the...
2015-12-28
878 reads
In any study of Data Types in SQL Server you are going to have to look at the various string...
2015-12-28
2,400 reads
Blogging and presenting have changed me for the better, and in ways I didn’t see coming. However, I know I wouldn’t have had them if it wasn’t for three things. Getting...
2015-12-28
16 reads
Blogging and presenting have changed me for the better, and in ways I didn’t see coming. However, I know I wouldn’t...
2015-12-28
703 reads
Another year is coming to an end and I am doing a review of which goals I have managed to...
2015-12-27
774 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