Save on IT/DevConnections this fall
For the first time in many years, I won’t be at IT/DevConnections this fall. I’m disappointed to miss the event,...
2017-05-25
550 reads
For the first time in many years, I won’t be at IT/DevConnections this fall. I’m disappointed to miss the event,...
2017-05-25
550 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-05-25
733 reads
I am so excited and honored to have been selected to speak at SQL Saturday Atlanta (#652) this year. This...
2017-05-25
331 reads
With the ability to create content delivery schedules, or to subscribe to report content delivery, it becomes very important to also know when the various reports are scheduled to...
2017-05-25
330 reads
Reporting Services
Over the past couple of articles I have illustrated some of the fun that can be had when dealing...
2017-05-25
1,112 reads
A quick post that is hopefully useful, I wanted a quick way to find the time, size of the database...
2017-05-25
335 reads
My First SELECT Statement Microsoft SQL Server makes it really easy for us to query tables. In SQL Server Management...
2017-05-24
179 reads
Welcome to a new series that I’m starting with a few colleagues at Pragmatic Works. The goal of this series...
2017-05-24
805 reads
If you are looking at providing high availability (HA) for SSAS, here are 3 options:
Install SSAS on a Windows Server...
2017-05-24
1,143 reads
Last week I started a multi-part series on Today I Learned (TIL) about Microsoft Azure. This is part two of...
2017-05-24
956 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