Azure SQL Database Execution Plan Differences
I’ve been exploring execution plans in Azure SQL Databases a lot lately. I’m getting a presentation together for some upcoming...
2013-01-30
1,915 reads
I’ve been exploring execution plans in Azure SQL Databases a lot lately. I’m getting a presentation together for some upcoming...
2013-01-30
1,915 reads
First of all I would like to thank Koen Verbeeck and Joost van Rossum for great suggestions that helped to...
2013-01-30
1,787 reads
Earlier on my blog I posted about how you can attach a database using T-SQL when no log file is...
2013-01-30
2,765 reads
by Steve Bolton
Anyone who has been following this series of self-tutorials has probably grown accustomed to me adding some...
2013-01-30
2,996 reads
If you have not signed up for the 24 Hours of PASS-Business Analytics you should be. This is a great...
2013-01-29
1,376 reads
During the last few years I've worked extensively with transactional replication and have written a handful of scripts that have...
2013-02-05 (first published: 2013-01-29)
2,779 reads
Have you ever needed to figure out which filegroup your tables are located within? If you had to do this,...
2013-02-06 (first published: 2013-01-29)
4,796 reads
A tribute is an expression of gratitude or praise. Last year I started a series about individuals who have impacted...
2013-01-29
1,639 reads
This is an annoying problem I have had a few times: I open a SQL Server Integration Services (SSIS) project...
2013-01-29
5,080 reads
As a former mentor Christian is used to me asking him all sorts of random questions, but this time it’s...
2013-01-29
1,541 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