Upcoming Webinars and Events
This coming week is packed full of fun events! On Wednesday, June 1st at 2pm Eastern, I’m participating in a...
2016-05-29
900 reads
This coming week is packed full of fun events! On Wednesday, June 1st at 2pm Eastern, I’m participating in a...
2016-05-29
900 reads
Continuation from the previous 82 parts, the whole series can be found at http://www.nikoport.com/columnstore/
A lot of things were changed in...
2016-05-29
1,007 reads
In the Data Mart, or the Data Warehouse world, there is a date dimension table in all schemas if you...
2016-06-06 (first published: 2016-05-29)
7,176 reads
Database backups are generated as part of the business continuity planning procedure. Disasters with server or its database are a...
2016-06-02 (first published: 2016-05-28)
4,117 reads
So, you just installed SQL Server 2016 and you’re pretty sure you chose the options to install the client tools...
2016-05-27
4,883 reads
I was honored to be selected to join many other great speakers in presenting for the recent 24 Hours of...
2016-05-27
1,002 reads
I know there has been a lot of drama in the community recently, much of it centered around what people...
2016-05-27
1,114 reads
Next week is SQL Saturday #491 in Pensacola. I’ll be there, along with a number of other great speakers. It’s...
2016-05-26
804 reads
In this post we’re going to introduce the basics of CPU scheduling.
In a computer system, only one thing can happen at a time. More specifically, only one task can...
2016-05-26
25 reads
In this post we’re going to introduce the basics of CPU scheduling.
In a computer system, only one thing can happen...
2016-05-26
1,406 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