Big Data architectures
Over the last few years I have been involved in reviewing the architectures of various companies that are building or have...
2016-05-12 (first published: 2016-04-29)
3,145 reads
Over the last few years I have been involved in reviewing the architectures of various companies that are building or have...
2016-05-12 (first published: 2016-04-29)
3,145 reads
When you undertake some performance improvement task, you think it is frustrating however at the same time you tend to...
2016-05-11 (first published: 2016-04-29)
3,723 reads
You have brains in your head. You have feet in your shoes. You can steer yourself in any direction you...
2016-04-28
818 reads
With the most recent announcement of Power BI’s inclusion in the Azure Trust Center, it is a good time to review...
2016-05-11 (first published: 2016-04-28)
2,690 reads
The April MVP nomination is Chris Yates (B|T).
Chris is one of those individuals that always have a positive outlook on...
2016-04-28
887 reads
UPDATE: the feature has changed since its introduction. For more information, see the update at the bottom of the post.
In...
2016-04-28
2,842 reads
My new course “Understanding and Using Essential Tools in Enterprise Linux 7” in now available on Pluralsight here!
This course targets IT professionals that design and maintain RHEL based enterprises....
2016-04-28
14 reads
My new course “Understanding and Using Essential Tools in Enterprise Linux 7” in now available on Pluralsight here!
This course targets...
2016-04-28
1,044 reads
data structures are art
If anyone thinks that working with complex data structures is boring... I don't know what world they...
2016-04-27
1,066 reads
This post is a requirement from one of my blog reader.
There are plenty of scripts available to get the backup...
2016-04-27
3,031 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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