SQL Server Podcasts
Great news, I have decided to do some podcasts on the fundamentals of SQL Server, my aim is to help...
2016-03-23
401 reads
Great news, I have decided to do some podcasts on the fundamentals of SQL Server, my aim is to help...
2016-03-23
401 reads
I submitted my letter just a few minutes ago. It’s a template, doesn’t take more than 5 minutes to fill out and...
2016-03-23
495 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-04-04 (first published: 2016-03-23)
3,233 reads
Azure SQL Data Warehouse (SQL DW) is a new platform-as-a service (PaaS) that distributes workloads across multiple compute resources, called massively parallel processing (MPP)....
2016-03-23
627 reads
Tomorrow (3/24/2016) at noon CT I’ll be presenting my SQL Server Security Basics session for the Pass Security Virtual Chapter....
2016-03-23
479 reads
Last week I received an email from one of our sysadmins asking why one of our databases kept showing as...
2016-03-31 (first published: 2016-03-22)
1,667 reads
Color coordination is important in report and dashboard design. We’ve seen theming and color pallet options in the prior iteration...
2016-03-22
1,184 reads
It’s coming in May. The official UK SQL Server 2016 launch event is SQL Bits and the conference returns to...
2016-03-29 (first published: 2016-03-22)
1,405 reads
It happens far too often: Once an ETL process has been tested and executes successfully, there are no further checks...
2016-03-29 (first published: 2016-03-22)
2,304 reads
SQL Server Service Broker is a messaging technology that’s baked right into the SQL Server engine. It was first introduced...
2016-03-30 (first published: 2016-03-22)
2,311 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