SQL Server 2012 RTM CU9
On August 20, Microsoft released SQL Server 2012 RTM Cumulative Update 9, which is Build 11.0.2419. I count seven fixes...
2013-08-22
1,594 reads
On August 20, Microsoft released SQL Server 2012 RTM Cumulative Update 9, which is Build 11.0.2419. I count seven fixes...
2013-08-22
1,594 reads
Learning new things can be daunting. First, you have to come up with the spare time. Then you have track...
2013-08-27 (first published: 2013-08-22)
2,450 reads
If a recruiter sends me a job description, the first question I ask is, “What is the pay rate”. If...
2013-08-22
1,051 reads
If you’ve got a Windows Phone, or any of the Windows devices that support podcasts, the Voice of the DBA...
2013-08-21
1,322 reads
One of the keys to being a successful technologist is being able to search for information. Google has a lot...
2013-08-21
981 reads
I’ve been at home through the whole month of August, restingworking hard, but it’s time to get on the road...
2013-08-21
868 reads
Recently attempting to install a new three node cluster I ran into a new issue. Once I was able to...
2013-08-28 (first published: 2013-08-21)
1,289 reads
I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated...
2013-08-21
1,339 reads
With the release of the revamped Integration Services in SQL Server 2012, a bunch of new deployment methods were introduced...
2013-08-21
7,752 reads
When your databases grow, operations, like a database backup and restore, are going to take a longer time to complete....
2013-08-21
19,483 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