In Memory OLTP – 2
Good day everyone , In last post
In Memory OLTP – 1
we saw the what is In Memory OLTP and what are the...
2016-12-09
560 reads
Good day everyone , In last post
In Memory OLTP – 1
we saw the what is In Memory OLTP and what are the...
2016-12-09
560 reads
One week nearer to Xmas! Before I spend the weekend braving the centre of town desperately wondering what presents to...
2016-12-09
377 reads
NOLOCK, some say it’s a fast option for queries and will never cause blocking, I say it’s quite dirty and...
2016-12-09
2,341 reads
I was building out a blog post about cardinality today and noticed that sys.dm_exec_query_stats was getting cleared my my Surface...
2016-12-27 (first published: 2016-12-08)
2,026 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-12-08
689 reads
I’ve been really excited about the new Data Migration Assistant (DMA) since I first heard about it. One of the...
2016-12-08
777 reads
As most of you know, one of the most fundamental uses of query store is to force query plans. Unlike...
2016-12-08
1,112 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-12-07
845 reads
Next week is the 2016 version of SQL in the City and you can register now to attend. It’s free...
2016-12-07
507 reads
In this final part of my series on SQL Server & Containers I’ll detail an option to run earlier versions of...
2016-12-26 (first published: 2016-12-07)
2,076 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