"fail fast" vs calligraphy
If you are a person inspired by ideas, you have probably encountered the concept of "fail fast". You probably also...
2012-11-15
696 reads
If you are a person inspired by ideas, you have probably encountered the concept of "fail fast". You probably also...
2012-11-15
696 reads
As I mentioned in my column in June, one of the many lessons I learned at the first-ever SQL Saturday...
2012-11-15
5,524 reads
Over the last couple of weeks I’ve set up a SSIS package that will loop through a group of servers...
2012-11-15
2,828 reads
Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL...
2012-11-15
1,174 reads
Gregg Robertson (b | t) has posted a fantastic page that contains a tremendous amount of information for those of you...
2012-11-15
712 reads
Frustration.
If you have ever had to work with Integration Services and data sources other than the Microsoft variety you know how frustrating...
2012-11-15
3,878 reads
As a new blogger, It is a little pain for me to blog on a technical topic.
It starts from learning, exprimenting, being comfortable with topic,...
2012-11-15
4,043 reads
SQL Server Version Upgrade - You have SQL Server running nicely with no issues or problems. The trouble is its SQL...
2012-11-15
1,181 reads
Become Microsoft Community Contributor.
I am very happy after receiving this affiliation from Microsoft last month.
My MCC badge is visible now...
2012-11-15
1,028 reads
As part of this Transaction Log internal series, In this article We are going to revisit some basic properties of Transaction log.Though architecture, purpose...
2012-11-16 (first published: 2012-11-15)
3,430 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...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
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