VMware vSphere 5.5 details trickling out
VMworld 2013 is this week in San Francisco, and some exciting details about the next version of the vSphere suite,...
2013-08-28
568 reads
VMworld 2013 is this week in San Francisco, and some exciting details about the next version of the vSphere suite,...
2013-08-28
568 reads
Every week I get a bunch of emails from recruiters about jobs that I am not qualified for (see Low-rate...
2013-08-27
1,151 reads
It is absolutely not cool or fun to pay money to learn new technology. One of the main complaints people...
2013-08-27
796 reads
Not too long ago I ran into a crazy situation where just about everything that could have gone wrong with...
2013-08-27
1,580 reads
You've spent a lot of time planning and building out a new SQL Server 2012 environment complete with Availability Group...
2013-08-29 (first published: 2013-08-27)
2,450 reads
DBAs rarely use the full potential of sys.dm_exec_query_stats. It’s common to see the queries for looking at the most expensive...
2013-09-04 (first published: 2013-08-27)
3,790 reads
By Steve Bolton
…………As I’ve said many times throughout this series of amateur mistutorials, SQL Server Data Mining (SSDM) is one...
2013-09-02 (first published: 2013-08-26)
2,787 reads
This post explains the simple steps to identify a duplicate indexes in all the databases. The duplicate index are more than...
2013-08-26
899 reads
This past weekend I made the relatively short (about 3 hours) trip to the Oklahoma City area to attend and...
2013-08-26
814 reads
If you’ve enabled TDE, you need to be sure you have a copy of the certificate that protects the Database...
2013-09-03 (first published: 2013-08-26)
1,898 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,...
Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal Sudirman...
Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec. Cilandak, Kota...
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