SSMS 2016 installation - The new SQL Server Management Studio 2016
This spackle hints toward installation of the SQL Server 2016 SSMS. The installation of SSMS 2016 is different and it's a...
2016-05-24
744 reads
This spackle hints toward installation of the SQL Server 2016 SSMS. The installation of SSMS 2016 is different and it's a...
2016-05-24
744 reads
In just a few weeks I’ll be doing the Buckeye Blitz. That is, a tour of user groups in Ohio...
2016-05-24
556 reads
One of the more interesting features in SQL 2016 is the integration of the R language. For those who haven’t seen it before, R is a statistical and data...
2016-05-24
23 reads
One of the more interesting features in SQL 2016 is the integration of the R language.
For those who haven’t seen...
2016-05-24
242 reads
One of the more interesting features in SQL 2016 is the integration of the R language.
For those who haven’t seen...
2016-05-24
749 reads
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging and queueing technology built into the SQL Server Database...
2016-05-24
227 reads
This post is part of a series on this blog that will explore SQL Server Service Broker, a native messaging...
2016-05-24
718 reads
SQLKover update: nowadays you would probably use package parameters to pass the directory value. However, they still have a default...
2016-06-03 (first published: 2016-05-24)
1,191 reads
The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation as it was the case until SQL Server 2014....
2016-05-24
20 reads
The installation of SSMS 2016 is different and it’s a separate installation. It’s not a part of the SQL Server installation as it was the case until SQL Server 2014....
2016-05-24
12 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