Migrate an SQL database from Windows to Linux using backup-and-restore and SMB Protocol
In an attempt decouple systems, we may modularize them. In most cases, we would need to move databases from one...
2017-05-16
553 reads
In an attempt decouple systems, we may modularize them. In most cases, we would need to move databases from one...
2017-05-16
553 reads
A while back, I posted an article about creating a WhiteList for access to SQL Server. Since then I have...
2017-05-16
4,718 reads
Whilst I was at PSCONFEU I presented a session on writing pester tests instead of using checklists. You can see it here
During the...
2017-05-16
710 reads
When using row level indexes there are two types Clustered and NonClustered both of which are there to make data...
2017-05-16
117 reads
So you are a SQL Server DBA, and you are responsible for a database, which gives you a hard time....
2017-05-16
585 reads
I have had several Query Store questions come in from customers lately. Some of the questions stemmed from things read...
2017-05-16
101 reads
I have had several Query Store questions come in from customers lately. Some of the questions stemmed from things read...
2017-05-16
387 reads
Part of a series looking back at Build 2017, going over the 20+ pages of notes I took.
Last week I...
2017-05-15
684 reads
Not the batch separator, but the GO language.
I’m always interested in learning new things, and GO has been one of...
2017-05-15
1,128 reads
If you are attending this year’s SQL Saturday in Atlanta, GA, on July 15, I urge you to attend my preconference training session...
2017-05-15
387 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