PASS Summit 2012 session videos online
If you are interested in viewing the recorded sessions for the PASS Summit 2012, you can order them on a USB flash...
2012-12-27
1,997 reads
If you are interested in viewing the recorded sessions for the PASS Summit 2012, you can order them on a USB flash...
2012-12-27
1,997 reads
I’m on holiday, but I have a set of predictions for 2013 coming on Jan 1. This is a little...
2012-12-27
987 reads
Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive provides...
2012-12-27
48 reads
Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large...
2012-12-26
420 reads
We know that we need to take special attention about NULL values while writing queries because they may lead us into...
2012-12-26
2,353 reads
I sincerely wish that everyone enjoyed their recent holidays and recent downtime with family, and pass on my hope for...
2012-12-26
1,517 reads
In my previous article, I have explained Big Data and Hadoop in details. In this article I would like to go little deeper with Pig. Pig is a high-level...
2012-12-26
42 reads
FOR XML CLAUSE: Sometimes we need to data in form of XML from
Database.SQL Server provide FOR XML Clause. For XML clause...
2012-12-26
797 reads
In my previous article, I have explained Big Data and Hadoop in details. In this article I would like to...
2012-12-25
455 reads
Bacon wrapped frog legs (twelve of them) for Christmas. No more drumming for these guys!! What could be better than bacon wrapped frog legs? Oh yeah, more Virtual lab...
2012-12-25
10 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...
Telp/Wa 62817825533 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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
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