PASS SQL Saturday Events : June 2013
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in...
2013-06-09
945 reads
PASS SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please note that in...
2013-06-09
945 reads
In my experience, code quality always trumps urgency because when code has been released that has questionable quality, it is...
2013-06-09
441 reads
Join SQL Server professionals from around the world for free online technical training and networking year round. PASS Virtual Chapters...
2013-06-09
1,022 reads
This is a temporary post that was not deleted. Please delete this manually. (155546b7-60c9-4c5a-baba-268c38ebcf1a – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
You just finished reading Temporary Post...
2013-06-08
629 reads
As part of theirIncremental Service Modelling, Microsoft have released SQL Server 2012 Service Pack 1 Cumulative Update #4.http://support.microsoft.com/kb/2833645
To apply this cumulative update package, you must be running SQL Server...
2013-06-08
30 reads
There may come a day when you want to embed a Power View report into a PerformancePoint dashboard or a...
2013-06-07
728 reads
I’ll be attending the very first SQLSaturday held in Cocoa Beach on July 27, 2013, and doing a brand new...
2013-06-07
627 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-06-07
954 reads
This past week I took my kids on a train ride from Philadelphia to Washington DC. It was their first...
2013-06-07
627 reads
My first time in Philadelphia (and in Malvern, the actual event location). I drove up Friday night for the speaker...
2013-06-07
801 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