That thing you want to do? Do the thing.
You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it?...
2017-07-29
696 reads
You're thinking of starting a blog, or teaching, or training videos. Will it pay off? Will it be worth it?...
2017-07-29
696 reads
Continuation from the previous 107 parts, the whole series can be found at http://www.nikoport.com/columnstore/
As we are approaching the RTM (release...
2017-07-29
857 reads
One of the recent tasks that I have undertaken seemed rather like an experiment to me. I set out to...
2017-07-28
717 reads
Wow, I can hardly contain my excitement. I was selected to speak at SQL Saturday Denver on September 16, 2017. I’ll...
2017-07-28
323 reads
For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...
2017-07-28
576 reads
For the past few years I’ve combined my love of professional football and analytics by releasing a series of Power...
2017-08-17 (first published: 2017-07-28)
3,521 reads
By Steve Bolton
…………This long-delayed series of amateur self-tutorials has been in the works ever since I began writing my A...
2017-07-28
551 reads
I really like the dbatools project. This is a series of PowerShell cmdlets that are built by the community and...
2017-07-28
473 reads
Hope you all had a good week. Been pretty chilled out here so I’ve been reading…
Announcing Azure Container Instances
Microsoft blog...
2017-07-28
392 reads
On my last post “SSRS Report Deployment Made Easy – 700 Times Faster” I showed how you can rely on the...
2017-08-15 (first published: 2017-07-27)
5,217 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