The Choices We Make
If you keep your head up and look around you’ll see the choices people make all the time. I saw...
2017-07-21 (first published: 2017-07-10)
1,984 reads
If you keep your head up and look around you’ll see the choices people make all the time. I saw...
2017-07-21 (first published: 2017-07-10)
1,984 reads
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the...
2017-07-10
259 reads
I’ve always been particularly cautious when it comes to deploying code to databases, some would say overly cautious.
Because of this...
2017-07-10
731 reads
Suppose, you have Transactional Replication configured in your production environment. There is a business requirement to add a new article to the...
2017-07-20 (first published: 2017-07-10)
12,184 reads
With SQL Server coming on Linux, some people will want to learn a bit of Linux. Or perhaps they need...
2017-07-07
1,031 reads
Microsoft has introduced two new disk sizes for Azure IaaS VMs in P40 (2TB) and P50 (4TB) for both managed...
2017-07-07
1,064 reads
I’ve started to look at the excellent dbatools.io to automate some of the checks that I routinely perform on my...
2017-07-07
914 reads
Final Lions Test tomorrow! The win last week sets up a thrilling series decider, if they win they’ll be the...
2017-07-07
803 reads
With some applications, there may be a need to pull data from other database instances, or from other databases within...
2017-07-06
784 reads
Top String FunctionsMachine Learning – Python IntegrationResumable Index Operations
Happy Learning!!
2017-07-06
461 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