Checkout SQL Server 2014 CTP1 and Windows 2012 R2 preview up in the cloud
You must be really busy spinning up VMs to test SQL Server 2014 CTP1 and Windows Server 2012 R2 preview.
If...
2013-06-26
1,625 reads
You must be really busy spinning up VMs to test SQL Server 2014 CTP1 and Windows Server 2012 R2 preview.
If...
2013-06-26
1,625 reads
I had a situation which forced me to do a feasibility study to move SQL server 2008 enterprise edition environment to standard edition. It is...
2013-06-26
1,703 reads
I'm speaking at SSWUG Summer Camp! Thankfully, I can be at home, in my pool AND be at summer camp...
2013-06-26
929 reads
I was pleased to see the email this morning announcing that community volunteers Erin Stellato, Ryan Adams, and Tamera Clark...
2013-06-26
1,256 reads
How will you back out if your change doesn’t work?! Always take a backup! There should always be a back...
2013-06-26
2,439 reads
What an interesting week this has been. On Monday Microsoft and Oracle announced a partnership that rocked the cloud world....
2013-06-26
1,366 reads
New versions have bombastic and catchy features. But a lot of times, the little, hidden features are the ones that...
2013-06-26
1,499 reads
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-26
2,673 reads
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
Earlier today I...
2013-06-26
7,428 reads
Sweet! SQL Server 2014 CTP1 is now available for download at Microsoft.com! Get it while it is hot, and start...
2013-06-26
754 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,...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
Comments posted to this topic are about the item Data Lost in the Cloud
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