Building a container running SQL Server 2014 SP2 Developer
One of the things about working with SQL in Docker is that you kinda have to use the images that...
2017-05-15 (first published: 2017-05-02)
2,447 reads
One of the things about working with SQL in Docker is that you kinda have to use the images that...
2017-05-15 (first published: 2017-05-02)
2,447 reads
In early June, I’ll be traveling to Pensacola, Florida for their annual SQL Saturday. This will be my second time...
2017-05-02
333 reads
The new SQL Server Master-Class in – why a SQLSentry Bootcamp
(DE) Die wichtigsten Infos gerafft zuerst: Vom 26. bis 28. Juni führe ich in Frankfurt eine neue SQL Server...
2017-05-02
50 reads
The new SQL Server Master-Class in – why a SQLSentry Bootcamp
(DE)
Die wichtigsten Infos gerafft zuerst:
Vom 26. bis 28. Juni...
2017-05-02
510 reads
A quick blog post to start the day, If you remember a few months ago I blogged about SQL Server...
2017-05-02
488 reads
For the past few months, one my customers had been trying to diagnose an issue with SQL Server paging out...
2017-05-02
1,328 reads
Last week I presented my session, SQL Server 2016 for Performance Tuning Lovers at the GroupBy conference. That was tons of...
2017-05-02
2,140 reads
I was once asked to add a new feature to an application. It was installed on multiple SQL Server instances...
2017-05-02
435 reads
There has been some discussion and concern over the changes to the speaker selection process for the PASS Summit. I’ve...
2017-05-12 (first published: 2017-05-01)
1,062 reads
In this module you will learn how to use the SandDance Power BI Custom Visual. The SandDance visual is an...
2017-05-16 (first published: 2017-05-01)
2,368 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...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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