2015-09-18
10 reads
2015-09-18
10 reads
2015-09-18
20 reads
on 19th sep 10.00 am pst, i will be speaking on “universal sql installations framework” @ sqlsaturday, san diego!!, if you...
2015-09-18
691 reads
We have four good candidates this year, of which two are incumbents. I was asked by Argenis and Tim to...
2015-09-17
634 reads
If you have on-prem data and want to copy it to Azure Blob Storage in the cloud, what are all...
2015-09-17
1,138 reads
Today I am going to continue with my PASS Election Questions and Answers series. Here is where you can find...
2015-09-17
622 reads
Today I get to talk about data types within Extended Events. This also means, I hope to be able to bring a little more clarity to the topic.
Related Posts:
Implicit...
2015-09-17
16 reads
Today I get to talk about data types within Extended Events. This also means, I hope to be able to...
2015-09-17
643 reads
SQLKover update: I love this trick! I use it daily, no kidding (except in weekends). Want to see it in live...
2015-09-17
658 reads
Another year, another set of elections. It’s that time where those who care about their industry and the future of...
2015-09-17
656 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