This Week In Data – Episode 11 (Debunking Popular Cloud Myths)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-11-02
480 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-11-02
480 reads
Last week was the 2016 Pass Summit, and this was one of the few times that PASS did not provide...
2016-11-02
584 reads
I’ll be at the last big SQL Server conference in the US for 2016 this December. VS Live is a...
2016-11-10 (first published: 2016-11-02)
922 reads
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the other day. A puzzled DBA was staring at a...
2016-11-02
22 reads
*Originally published in our old blog on January 2009
I ran into a very simple SQL Server performance related question the...
2016-11-02
216 reads
This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return...
2016-11-11 (first published: 2016-11-02)
1,246 reads
As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016....
2016-11-08 (first published: 2016-11-02)
3,330 reads
I saw something like this the other day. My first thought was “Hu, never seen that before.” My second thought...
2016-11-02
882 reads
It Trick or Treat on Monday...Two days on and I have a treat for you. Learning Tree's Great Value IT...
2016-11-02
497 reads
In my last post I showed you how to conduct an assessment using DMA – Database Migration Assessment tool v2.0 This...
2016-11-02
596 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