T-SQL Tuesday #121: Gifts received for this year
At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve gotten during the year. I’ve been gifted with a lot of things this year personally...
2019-12-10
12 reads
At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve gotten during the year. I’ve been gifted with a lot of things this year personally...
2019-12-10
12 reads
At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve gotten during the year. I’ve been gifted with a lot of things this year personally...
2019-12-10
14 reads
After nearly a year of work, starting with the proposal that I finished writing in a hospital last year the book is finished and off to be published and...
2019-10-02
50 reads
After nearly a year of work, starting with the proposal that I finished writing in a hospital last year the book is finished and off to be published and...
2019-10-02
17 reads
After nearly a year of work, starting with the proposal that I finished writing in a hospital last year the book is finished and off to be published and...
2019-10-02
14 reads
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
43 reads
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
22 reads
This month’s topic is wide open to anything you could think of that had to do with SQL on Linux from something technical on how to implement it or...
2019-07-17
12 reads
Hey look who is hosting T-SQL Tuesday, it is me, and I’m late. Sorry I broke my demo machines for Linux and had to set up everything again so...
2019-07-12
28 reads
Hey look who is hosting T-SQL Tuesday, it is me, and I’m late. Sorry I broke my demo machines for Linux and had to set up everything again so...
2019-07-12
12 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. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
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...
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