Calculating DTU in Azure SQL Database
A few months ago, I posted a question over on ask.sqlservercentral.com. In a nutshell, it was how do you measure...
2016-09-06 (first published: 2016-08-24)
2,697 reads
A few months ago, I posted a question over on ask.sqlservercentral.com. In a nutshell, it was how do you measure...
2016-09-06 (first published: 2016-08-24)
2,697 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-08-24
1,354 reads
We know you you’ve been dying to know, what is TWID? Drumroll please…. We’re excited to announce the launch of...
2016-08-24
495 reads
SQL Server 2016 introduces a very cool new feature called real-time operational analytics, which is the ability to run both...
2016-08-24
685 reads
To support more and more people jumping to Columnstore INdexes, OH22 have decided to open another public 1-day deep dive...
2016-08-24
422 reads
A business case that requires the usage of Master Data Services finally landed in my desk. As part of delivering...
2016-08-24
650 reads
Continuing my exploration of Azure the next logical step seemed to be copying an on-premise database up to the cloud....
2016-09-06 (first published: 2016-08-24)
1,843 reads
What is this gaping hole in the coverage of Extended Events? To be honest, it is not a very complicated topic or very difficult gap to fill. It's just...
2016-08-24
18 reads
I have a fairly large backlog of articles that are in progress or that are planned for my series about...
2016-09-05 (first published: 2016-08-24)
1,511 reads
On episode of one of our favorite podcasts – 10 on Tech from ActualTech Media – recently focused on a discussion with James...
2016-08-24
442 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