Converged virtual architectures and SQL Server licensing
Hyper-converged compute architectures, meaning clusters of physical servers with self-contained storage configured for a traditional SAN-less solution, are growing in...
2016-07-08
601 reads
Hyper-converged compute architectures, meaning clusters of physical servers with self-contained storage configured for a traditional SAN-less solution, are growing in...
2016-07-08
601 reads
We've made it to the final day, day 4 of Learning Tree course 294 Influence Skills: Getting Results without Direct Authority.
Today...
2016-07-08
526 reads
Hi friends, Microsoft has announced the release of three new SQL 2016 certifications, based on the different working database professional’s...
2016-07-08
815 reads
For those of you who just started to manage SQL server might wonder why SQL server use so much memory....
2016-07-08
875 reads
This is the 1st in a series of posts on SQL Server and Continuous Integration. Some of the tools I’ll be...
2016-07-07
767 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-07-07
884 reads
I see a lot of confusion when it comes to creating a private cloud. Many seem to think that by...
2016-07-07
1,366 reads
Steve Jones (b/t) has been asking people to post their Pass Summit submissions and the reviews that came back, along...
2016-07-07
453 reads
The main news this morning: Wales' heroic efforts at the Euros came to end last night with a 2-0 defeat...
2016-07-07
400 reads
SQL Server uses tempdb for many features, including row versioning, service broker and query execution amongst others. During the execution...
2016-07-07
3,877 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...
Telp/Wa 62817825533 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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