SQL Community Speakers – Why We Do It
I started this post over a year ago and have just now come back around to finish it. Over the...
2013-07-24
661 reads
I started this post over a year ago and have just now come back around to finish it. Over the...
2013-07-24
661 reads
Building Connectors Is Crap in SSIS – Updated What else can I say. I finally broke when I had to build a flat file connector with 258 columns that...
2013-07-24
19 reads
Most of you probably get that there will always be a bottleneck in a system. You implement a fix in...
2013-07-24
589 reads
You absolutely need to learn more. I need to learn more (lots more). We all should be constantly learning more...
2013-07-24
575 reads
I got to go to the Pass Summit in 2011 and had a fantastic time despite some travel issues caused...
2013-07-24
670 reads
SQL Saturday #222 in Sacramento, CA, is coming fast! This Saturday, July 27, I will be presenting a little pre-show...
2013-07-24
676 reads
SQL Server 2012 supports contained databases and partially contained databases, which provide a high degree of isolation from the database...
2013-07-24
1,252 reads
DBAs are most responsible for configuring and managing of database infrastructure, database file locations, database encryption which do not have...
2013-07-24
661 reads
In our earlier posts, we have discussed about different types of pages.Data Pages, GAM and SGAM,PFS page and IAM page. In this post, we will try to understand the Differential Change...
2013-07-24
1,858 reads
On July 15, Microsoft released SQL Server 2008 Service Pack 3 Cumulative Update 12, which is Build 10.0.5844. I count...
2013-07-23
718 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