Notes from the March 2016 oPASS Meeting
Quick notes:
Chinese food instead of pizza (thanks Shawn!)The wine bar is doing some remodeling to make better use of the...
2016-03-28
602 reads
Quick notes:
Chinese food instead of pizza (thanks Shawn!)The wine bar is doing some remodeling to make better use of the...
2016-03-28
602 reads
PASS SQLSaturdays are free 1-day training events for SQL Server professionals that focus on local speakers, providing a variety of...
2016-03-28
481 reads
I love presenting sessions because you get so many interesting questions. For example, what happens with Optimize for Ad Hoc...
2016-04-11 (first published: 2016-03-28)
1,950 reads
As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly...
2016-04-08 (first published: 2016-03-28)
1,493 reads
The Nordic SQLNexus conference is taking place in Copenhagen on May 2-4. I’ve never been to the event, or the...
2016-03-28
601 reads
I answered an interesting question on SE today (ever notice how many posts come from stuff I read on forums?)...
2016-03-28
511 reads
When you look after more than a few SQL Servers you will need to perform the same actions against a...
2016-04-08 (first published: 2016-03-28)
1,708 reads
With SQLPort approaching it’s 6th birthday (21st of April), I have to admit that the works on the user group...
2016-03-27
486 reads
Well, after many late nights I have finally produced a set of podcasts – Bite size style – therefore called SQL Bite...
2016-03-27
286 reads
1. Tell me about yourself.
Answer - Give summary of your past education and work, skills, and achievements and include your strong...
2016-03-27
172 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