Microsoft: 1 Year in, how's it going?
Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the...
2017-03-10 (first published: 2017-03-01)
2,240 reads
Hello Dear Reader, one year ago today it was leap year, February 29th 2016. So I'm a year older, the...
2017-03-10 (first published: 2017-03-01)
2,240 reads
Another great teaching opportunity landed in my lap this week. I got an email from a coworker looking for some...
2017-03-09 (first published: 2017-03-01)
3,833 reads
On Monday, Redgate released v1.0 of SQL Clone, and I’m excited that the product is finally available. I’m excited because...
2017-03-01
2,641 reads
One of the most common ways to get an event notification is by email. So what happens when you get...
2017-03-01
393 reads
I’ll be giving a webinar for MSSQLTips.com at March 30th. It’s a sponsored webinar, meaning there will also be a vendor...
2017-03-08 (first published: 2017-03-01)
1,515 reads
Step By Step configuring Windows 2012 R2 fail over cluster How to setup windows cluster for Always on Availability Groups
AlwaysOn Availability Groups: Step by Step Setup Step by Step procedure to...
2017-03-01
11 reads
Step By Step configuring Windows 2012 R2 fail over cluster How to setup windows cluster for Always on Availability Groups
AlwaysOn Availability...
2017-03-01
675 reads
One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage to setup Always on availability. it can be configured...
2017-03-01
19 reads
One of my client requirement is to install Always on availability groups for SQL databases. You don't require shared storage...
2017-03-01
3,040 reads
I’ve been working with containers for a while now and one of the questions that always gets asked when I...
2017-03-01
2,024 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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