A Great SQL in the City 2015 Seattle
Yesterday was the Seattle edition of the 2015 Redgate Software SQL in the City tour. I was in London a...
2015-10-27
542 reads
Yesterday was the Seattle edition of the 2015 Redgate Software SQL in the City tour. I was in London a...
2015-10-27
542 reads
Yesterday was the Seattle edition of the 2015 Redgate Software SQL in the City tour. I was in London a...
2015-10-27
694 reads
A little over six months ago, I suggested the SQL New Blogger Challenge. I thought that maybe a few people...
2015-10-27
460 reads
The premise of the article today is to get a little exposure to some of the internals that may cause a bit of curiosity for you. I will share...
2015-10-27
9 reads
For me, some of the most fun stuff with SQL Server is diving deep into the internals. Diving into the...
2015-10-27
604 reads
As of October
1, 2015, I am no longer a Microsoft SQL Server MVP. Countless of my colleagues met the same...
2015-10-27
1,765 reads
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
301 reads
It’s Pass 2015 this week and I’m attending (seriously I’m unbelievably chuffed)! As they’ll be a shedload of blogs about...
2015-10-27
516 reads
I’m heading over to the Yardhouse (4th and Pike) as soon as SQL in the City is finished and should...
2015-10-26
408 reads
I’m heading over to the Yardhouse (4th and Pike) as soon as SQL in the City is finished and should...
2015-10-26
564 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