Backup Deployed Sessions
There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth...
2015-10-12 (first published: 2015-10-05)
547 reads
There is a wealth of information within Extended Events. Throughout this series, I have been working on exposing that wealth...
2015-10-12 (first published: 2015-10-05)
547 reads
Well I’ve done it. I’ve spoken at an event. I’ll discuss how I felt about it and what I learned...
2015-10-05
549 reads
In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...
2015-10-04
343 reads
In my previous blog I explained about clustered index (https://sqldose.wordpress.com/2015/09/20/clustered-index-and-related-interview-questions/ ).
Considering that we are versed with the concept of heap,...
2015-10-04
498 reads
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
483 reads
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
317 reads
In our final post in our “Load Testing Your Storage Subsystem with Diskspd” series, we’re going to look at output...
2015-10-04
3,660 reads
Thanks for joining us at SQL Saturday Columbus today on a gorgeous day to go inside and learn about SQL...
2015-10-03
521 reads
It’s been a long time since I wrote about my workspace, however I made a change recently. This was the...
2015-10-02
371 reads
It’s been a long time since I wrote about my workspace, however I made a change recently. This was the...
2015-10-02
625 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