Upcoming PASS Events
There is a new website from PASS. Go to Pass.org instead of SQLPass.org. The change does not really concern me...
2017-02-23
486 reads
There is a new website from PASS. Go to Pass.org instead of SQLPass.org. The change does not really concern me...
2017-02-23
486 reads
This is the first in a series of blog posts about how great SQL Server 2016 is, and why you should...
2017-02-23
1,508 reads
Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PMSQL Server has had ways to encrypt data in the past - for...
2017-02-23
22 reads
Join Webinar on SQL Server 2016 - Always Encrypted / Security. Thu 2/23/2017 from 12 PM to 1 PM
SQL Server has had ways to...
2017-02-23
670 reads
[read this post on Mr. Fox SQL blog] [UPDATED 7 JUN 2020 – ADDED NEW TEXT ANALYTICS v3.0 FEATURES!] Just last week we had the fantastic opportunity to present at Microsoft...
2017-02-22
23 reads
[read this post on Mr. Fox SQL blog]
Just last week we had the fantastic opportunity to present at Microsoft Ignite 2017 in...
2017-02-27 (first published: 2017-02-22)
2,885 reads
Nothing special - just signed with renewed code sign certificate, small fixes, etc
Have fun!
Wait a minute! Almost forgot.
More great news coming...
2017-02-22
814 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-02-22
1,146 reads
In several of my last few blog posts, I’ve shared several methods of getting internal information from a database by...
2017-02-22
432 reads
I just wanted to remind everyone that the SQL Saturday in Chicago is coming up, and that both Adam Machanic...
2017-02-22
356 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