Conversation History: The Continuing Case Against GUIDs
We had a cooperative relational database design exercise at the office last week as part of our regular department "Lunch...
2013-03-08
1,247 reads
We had a cooperative relational database design exercise at the office last week as part of our regular department "Lunch...
2013-03-08
1,247 reads
In my earlier post, we have discussed about Data,GAM,SGAMand PFS pages. In this post, let us try to understand about...
2013-03-07
7,887 reads
I have been using Microsoft’s Master Data Services (MDS) on a daily basis for the last 8 months. I also...
2013-03-07
3,144 reads
In yesterdays duplicate index blog post, I mentioned that there would be an update to the index analysis stored procedure...
2013-03-07
727 reads
But We’ve Never Had a Disaster Before!
This week, some of my Twitter followers were kind enough to chime in on...
2013-03-07
705 reads
This weekend is SQL Saturday #187 in Richmond, VA. Today’s a travel day for me, as I head out early...
2013-03-07
819 reads
Reading about the motherboard choices took a while. Because I had already decided on a CPU, the Intel I7 I...
2013-03-07
790 reads
I’m so exciting to announce that the SQL Saturday Kosovo is going to be held on May 18, 2013 and...
2013-03-07
1,127 reads
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are...
2013-03-07
2,008 reads
Ahhh – Motor City. What a fun place to start my 2013 SQL Saturday rounds! Detroit, here I come! You all...
2013-03-07
618 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