ALTER INDEX….ABORT!
I know there are people out there that will be going from older versions of SQL to SQL Server 2016, yes...
2016-10-06
497 reads
I know there are people out there that will be going from older versions of SQL to SQL Server 2016, yes...
2016-10-06
497 reads
We’ve been monitoring the weather all week, thinking that today was the day we had to decide. We didn’t want...
2016-10-05
430 reads
SQL Server 2014 was one amazing release, which had a very interesting codename – “Hekaton”, meaning that the principal news in...
2016-10-05
549 reads
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-10-05
447 reads
Why I’m Running Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears to be the right year to do this....
2016-10-05
65 reads
Why I’m Running
Over the past few years, I’ve been considering running for the PASS Board of Directors and this year appears...
2016-10-05
917 reads
A recent Microsoft blog post announced that they are releasing five new Microsoft Certified Solutions Expert (MCSE) and Developer (MCSD) specialties. ...
2016-10-05
789 reads
No one reads blogs any more.
Twitter is dying.
Facebook is broken.
LinkedIn? Please.
G+. Is that even on any more?
Where do we go...
2016-10-05
493 reads
I saw an interesting question today about rounding. Specifically they always wanted to round down. Now as it happens that...
2016-10-05
663 reads
Here is an overview of the articles I published in the third quarter of 2016.
What’s New in SQL Server Integration Services...
2016-10-05
534 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