The ROI of SQLSaturday for PASS & Decreased Event Funding
Returning to the post about Making SQSaturday Sustainable (see also a follow post about addressing concerns) it mentioned two topics...
2016-08-05 (first published: 2016-07-30)
1,493 reads
Returning to the post about Making SQSaturday Sustainable (see also a follow post about addressing concerns) it mentioned two topics...
2016-08-05 (first published: 2016-07-30)
1,493 reads
In a post titled The Future of the BA Community PASS announced that there would be no Business Analytics conference...
2016-07-30
832 reads
This year’s involvement in VMware‘s VMworld conference is up on the content catalog! I am extremely proud to announce my participation...
2016-07-29
885 reads
Why I like SQL Sentry Plan Explorer. I am going to be honest here, before attending SQLSKILLS Immersion training I...
2016-07-29
649 reads
Continuation from the previous 85 parts, the whole series can be found at http://www.nikoport.com/columnstore/
With the release of SQL Server 2016,...
2016-07-29
980 reads
A bit of history
Long ago there were such things called diverters. The phone company used them so employees could dial...
2016-07-29
922 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-07-28
942 reads
My friend and coworker Melissa Coates (aka @sqlchick) messaged me the other day to see if I could help with a...
2016-07-28
815 reads
I’ll be giving a webinar on the new features of Integration Services 2016.
When? August 11, 2016
Where? On the MSSQLTips.com website. You...
2016-07-28
826 reads
Last week PASS published some new guidance for SQLSaturday that sets a 600 mile rule (has since been updated, still...
2016-07-28
1,355 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