Another reason that T-SQL beats the GUI
In IT, we have a few very solid and universal principles that no one ever argues with. The first of...
2011-11-14
582 reads
In IT, we have a few very solid and universal principles that no one ever argues with. The first of...
2011-11-14
582 reads
Each Friday on @Midnight">DBAs@Midnight (my live weekly webshow, 11pm CST at webshow.MidnightDBA.com!) I don’t feel like I have enough time...
2011-11-04
940 reads
Calling all unpublished* SQL Server folk!
I’m now accepting abstracts for a new project we’re putting together – a community-written book of...
2011-11-01
876 reads
Let’s apply a little backup and restore knowledge, eh wot?
I introduce this whole concept in Applied SQL: You Have Homework....
2011-10-26
815 reads
We’ve had some BIG fun this week, relatively speaking, with #SQLSue and #SQLIdiot and just general #SQLcraziness. We’ve had several...
2011-10-20
604 reads
This morning this caught my eye on SQLServerCentral.com: Maximizing SQL Server Throughput with RSS Tuning(it came with a catchy SQLCAT...
2011-10-19
680 reads
Note: I will be updating this post with, er, updates as I get them…
We’ve had our fair share of plagarists,...
2011-10-18
686 reads
Today’s keynote with Dr. DeWitt starts at 8:15am EDT. Click here to watch today’s keynote live. For information on today’s...
2011-10-14
1,694 reads
Today’s keynote with Quentin Clark starts at 8:15am EDT. Click here to watch today’s keynote live. For information on today’s...
2011-10-13
602 reads
Jes Borland Hosts the 2011 WIT Luncheon
Click here to watch today’s WIT luncheon live. For information on today’s luncheon and...
2011-10-13
887 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