Showplan comparison
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans by right clicking and choosing the “Compare Showplan” option...
2016-06-02
13 reads
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans by right clicking and choosing the “Compare Showplan” option...
2016-06-02
13 reads
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans by right clicking and choosing the “Compare Showplan” option...
2016-06-02
16 reads
I want to once again thank everyone who attended my 24 Hours of PASS session last week. I especially appreciate...
2016-06-02
807 reads
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans...
2016-06-02
173 reads
As an IT professional we are used to spending a lot of time learning about new technologies or how we...
2016-06-09 (first published: 2016-06-02)
4,873 reads
In case you haven't heard, SQL server 2016 is generally available today! If you haven't try it out, you should...
2016-06-02
859 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-06-01
535 reads
Today is the day: SQL Server 2016 is available for download! You can download all the versions (enterprise, standard, web,...
2016-06-01
982 reads
(DE)
Es ist soweit: Der neue SQL Server, in meinen Augen das beste Release seit vielen, wenn nicht gar überhaupt,...
2016-06-01
561 reads
I was working on generating scripts for logins, users and server roles and I could able to to generate scripts...
2016-06-01
630 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