I am a Microsoft Data Platform MVP
My First Microsoft SQL Server MVP Award
Today, I have achieved an SQL Someday moment. I am excited to share some exciting...
2016-07-01
597 reads
My First Microsoft SQL Server MVP Award
Today, I have achieved an SQL Someday moment. I am excited to share some exciting...
2016-07-01
597 reads
I’m extremely honored to be named Microsoft Data Platform MVP for the third year in a row! I thank the...
2016-07-01
306 reads
The db.createUser(user, writeConcern) method used to create users.We need to provide the username, password and roles
The definition of createUser as follows
{user:"<name>",pwd:"password>",customData:{<User...
2016-07-01
418 reads
The developments over the last few months in the data community had brought us to an interesting place. We’re going to have SQL on Linux and now we also...
2016-07-01
16 reads
The developments over the last few months in the data community had brought us to an interesting place. We’re going...
2016-07-01
702 reads
I thought that this would be useful for others – couple of scripts that I have been using in Azure for...
2016-07-01
218 reads
This is post #2 of my BimlScript – Get to Know Your Code Nuggets series. To learn about text nuggets, see my...
2016-07-01
486 reads
Python Distributions Python is free and open source software. A programmer could download the executables for Python directly from the...
2016-07-01
619 reads
(DE)
Der SQL Server 2016 ist da, und damit nun auch die „Version 2“ der In-Memory OLTP Engine, wenn man...
2016-06-30
1,032 reads
Brent Ozar recently published the feedback he got on his abstract submissions for PASS Summit 2016 and, as he often...
2016-06-30
905 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