Great Value IT Training early August Update
Its that time of the week when get the latest Learning Tree courses that have been available for £750 plus...
2016-08-03
351 reads
Its that time of the week when get the latest Learning Tree courses that have been available for £750 plus...
2016-08-03
351 reads
There isn’t really a need to do what I am doing in this blog post but I guess one reason...
2016-08-03
211 reads
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open...
2016-08-02
902 reads
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open...
2016-08-02
32 reads
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open...
2016-08-02
51 reads
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open...
2016-08-02
48 reads
Deploying a dacpac from powershell should be pretty easy, there is a .net api which you can use to open a dacpac, compare to a database and either create...
2016-08-02
6 reads
This month I am asking you to not only write a post but to do a little homework - first. In other words, plan to do something, carry out...
2016-08-02
24 reads
Sharpen Something
Last week I sent out the invite for the August TSQL Tuesday blog party. In that invite I promised...
2016-08-04 (first published: 2016-08-02)
1,397 reads
There are many ways to migrate an “earthed” SQL Server database to Azure, for this article I want to show...
2016-08-02
238 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