How to collected inventory for SQL Server using Microsoft Assessment and Planning (MAP) tool
Hi friends, We need to collect inventory for database migration as well as platform to set up environment for migration,...
2016-09-30
1,114 reads
Hi friends, We need to collect inventory for database migration as well as platform to set up environment for migration,...
2016-09-30
1,114 reads
When you need to manage a number of SQL instances, monitoring them becomes one of your priority task. In some...
2016-09-30
1,908 reads
No pressure. None whatsoever. There is just an Auditor standing behind you waiting for you to pull a list of...
2016-10-06 (first published: 2016-09-29)
2,039 reads
I was playing with some Extended Events recently. If you haven’t tried, I’d encourage you to do so. However, working...
2016-09-29
1,078 reads
Cortana Intelligence Solutions is a new tool just released in public preview that enables users to rapidly discover, easily provision, quickly experiment...
2016-09-29
927 reads
I was just asked how many times I’ve been to the PASS Summit. This year will be my 12th consecutive...
2016-09-29
766 reads
On October 10, I will come back to present in one of my favorite SQL Server conferences – SQL Server Days...
2016-09-29
620 reads
As regular readers of this blog will know I teach some data courses for Learning Tree. Recently Learning Tree has...
2016-09-29
795 reads
One of the most interesting and talked about topic in database field is Index. I am writing this Series of...
2016-09-29
872 reads
I have been eager to write this blog post for a while now. I want to share my experience of...
2016-09-29
887 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