Tuesday Morning SQL Break – November 24, 2015
It’s Tuesday time for this week’s one day late blog and twitter round-up for last week. If you haven’t already, follow me...
2015-11-24
540 reads
It’s Tuesday time for this week’s one day late blog and twitter round-up for last week. If you haven’t already, follow me...
2015-11-24
540 reads
Take a minute and look around you. Automation is all around you; whether you see it or not processes are...
2015-11-30 (first published: 2015-11-24)
1,516 reads
Database Mirroring Error 1418
Hello Everyone.
This post will be helpful in resolving the error 1418 that we may come across when...
2015-11-24
2,813 reads
Installing and configuring SQL Server Master Data Services (MDS) is like a box of chocolates: you never know what you’re...
2015-12-01 (first published: 2015-11-24)
4,527 reads
SSDT is great but one thing that is not so great is the performance of the publish. I am not...
2015-11-24
461 reads
SSDT is great but one thing that is not so great is the performance of the publish. I am not complaining, I understand it does a lot and is...
2015-11-24
13 reads
SSDT is great but one thing that is not so great is the performance of the publish. I am not...
2015-11-24
27 reads
SSDT is great but one thing that is not so great is the performance of the publish. I am not...
2015-11-24
58 reads
SSDT is great but one thing that is not so great is the performance of the publish. I am not...
2015-11-24
58 reads
With SQL server 2016 around the corner, I would like to share some of my thought on the usage for...
2015-11-24
752 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