Why You Need a Data Warehouse
Introduction
You likely have heard about data warehousing, but are unsure exactly what it is and if your company needs one....
2013-07-25 (first published: 2013-07-18)
5,992 reads
Introduction
You likely have heard about data warehousing, but are unsure exactly what it is and if your company needs one....
2013-07-25 (first published: 2013-07-18)
5,992 reads
If you have a set of columns inside your table that you want to allow nulls in, however if one...
2013-07-18
1,247 reads
I’ve been doing various clean up tasks this week related to the blog, with part of that being a review...
2013-07-18
835 reads
Late last night in the
Halls of Congress, a grand gathering of planners took place to form that
which we...
2013-07-19 (first published: 2013-07-18)
1,718 reads
Upgrading an instance is a process in which you upgrade an existing instance of SQL Server to SQL Server 2012....
2013-07-18
597 reads
In the last post we have discussed about Set Statistics IO and how it will help us in the performance tuning. In this post we will discuss about the Set...
2013-07-18
92 reads
I make a point of reading DBAReactions on a fairly regular basis and today while reading it I was lead...
2013-07-17
843 reads
I just saw a post from Brian Kelley about the new PASS Security Virtual Chapter launching and the first presentation...
2013-07-17
609 reads
In the last post we have discussed about Set Statistics IO and how it will help us in the performance tuning....
2013-07-17
19,722 reads
Next week I travel to Sacramento, CA for the SQL in the City Seminar – Stairway to Deployment on Friday, July...
2013-07-17
1,083 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