Create ETL solutions faster with metadata driven development – Session Materials
Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great...
2013-11-13
1,162 reads
Last week was the 2013 edition of the SQL Server Days. It was an amazing event: there was a great...
2013-11-13
1,162 reads
Scenario: I have given a new storage by SAN team to move my database files and logs from old drive...
2013-11-13
1,510 reads
This isn't a normal post. This one is directed to newer people, those who feel pushed around a bit at...
2013-11-13
405 reads
So here it is, the second Tuesday of the month. This means that it is time for our favorite Tuesday...
2013-11-13
631 reads
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host the party, and everyone that want’s to can write...
2013-11-12
15 reads
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host...
2013-11-12
786 reads
This month’s T-SQL Tuesday is hosted by yours truly. Our topic this month is simply the Cloud. If you work in IT there’s approximately zero chance that you’ve managed...
2013-11-12
24 reads
This month’s T-SQL Tuesday is hosted by yours truly. Our topic this month is simply the Cloud. If you work in IT there’s approximately zero chance that you’ve managed...
2013-11-12
18 reads
This month’s T-SQL Tuesday is hosted by yours truly. Our topic this month is simply the Cloud. If you work...
2013-11-12
947 reads
I have been using Power BI the past few weeks (see my video of all the features) after I was invited...
2013-11-12
1,384 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