Advent of Code #2
This one gives you a 1000 rows of package dimensions. You calculate the surface area needed for wrapping paper, plus...
2015-12-23
681 reads
This one gives you a 1000 rows of package dimensions. You calculate the surface area needed for wrapping paper, plus...
2015-12-23
681 reads
I think sometimes those of us that have been doing database administration/development for a while take it for granted that...
2015-12-23
278 reads
The year 2015 is coming to an end and I wanted to publish my currently planned roadmap for the CISL...
2015-12-23
448 reads
If you want your skills to be sharp, you practice. If you want to get yourself to actually do practice, you call it a “challenge”. This is what the...
2015-12-23
59 reads
If you want your skills to be sharp, you practice. If you want to get yourself to actually do practice,...
2016-01-04 (first published: 2015-12-23)
1,565 reads
I couldn’t think of anything really fun to post for Christmas Eve-Eve and I’ve been busy buying and wrapping presents...
2015-12-23
511 reads
Around 3.5 Months ago in September of 2015, I have announced the first public release of the CISL – Columnstore Indexes...
2015-12-22
888 reads
I am glad to share that the latest version of CISL – Columnstore Indexes Scripts Library 1.0.4 is finally released.
By all...
2015-12-22
484 reads
Time is slowly ticking toward 0:00 on the clock. As I look around I couldn’t help but reflect back on...
2015-12-22
507 reads
I just donated $10 to Wikipedia. I use it and find it useful, so I don’t mind contributing so that...
2015-12-22
575 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