5 Features SQL Server Doesn’t Need
Paul Randal (@PaulRandal) started this chain of blog posts with his post, What 5 Things Should SQL Server Get Rid...
2010-05-17
797 reads
Paul Randal (@PaulRandal) started this chain of blog posts with his post, What 5 Things Should SQL Server Get Rid...
2010-05-17
797 reads
On my current project I decided to be flexible and allow the use of Linq to SQL to try to...
2010-05-13
279 reads
OPASS had it’s May meeting on Thursday the 6th sponsored by Confio with Dean Richards presenting Tuna Helper for the...
2010-05-10
499 reads
Join us tonight for our May OPASS meeting at the SQL Share Offices 225 S. Westmonte Drive, Suite 2010, Altamonte...
2010-05-06
395 reads
We recently decided to use Team Foundation Server as our source control and, really, project management system. This decision was...
2010-05-06
482 reads
The Issue
Being involved in PASS and the SQL Server community via blogging and Twitter, I get to see and hear...
2010-05-03
1,047 reads
Last Saturday, April 24, I presented my session, Why I Use Stored Procedures and You Should Too, at SQLSaturday #41-Atlanta, see...
2010-04-29
1,452 reads
I had the opportunity to go present at SQLSaturday #41-Atlanta this past weekend (April 24, 2010) and I had a...
2010-04-27
825 reads
SQLSaturday #49 - Orlando is now live on the SQLSaturday web site. It will be held on October 16th at Seminole...
2010-04-22
410 reads
I have the privilege of being able to attend and present at SQLSaturday #41 – Atlanta this weekend. This will be...
2010-04-21
358 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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