Webinar on Change Tracking for Data Warehouse Loads
Join me online on Tuesday, November 15th at 1:00PM as I host a webinar entitled “Managing Data Warehouse Incremental Loads...
2016-11-04
429 reads
Join me online on Tuesday, November 15th at 1:00PM as I host a webinar entitled “Managing Data Warehouse Incremental Loads...
2016-11-04
429 reads
[2016-Nov-04] Open data is like a soup, some people like it hot (or made with all the latest updates); some people...
2016-11-04
624 reads
I have a need to encrypt a column within my SQL Database (Azure). I decided to use Always Encrypted. This feature...
2016-11-04
734 reads
Recently, while applying SQL Server 2012 Service Pack 3, encountered the following error and SQL Patch failed to upgrade.
"The patch...
2016-11-04
6,970 reads
I am so glad that the time has arrived to announce my next project – the Columnstore.NET! This site will incorporate...
2016-11-03
399 reads
Microsoft usually has some interesting announcements at the PASS Summit, and this year was no exception. I’m writing a set...
2016-11-03
644 reads
I recently wrote an introductory post about the importance of statistics. I just received a reinforcement on how important they...
2016-11-10 (first published: 2016-11-03)
1,236 reads
Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...
2016-11-03
439 reads
Got back from Summit on Saturday and I’m still totally in the moment. I came back with so many new...
2016-11-03
222 reads
I thought that it would be handy to capture some Perfmon graphs of what happens to backup throughput and CPU...
2016-11-03
485 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