SQLSaturday #49 – Orlando Pre-Conference with Louis Davidson
The planning team of SQLSaturday #49 – Orlando and OPASS are proud to announce that there will be a pre-conference seminar...
2010-07-12
780 reads
The planning team of SQLSaturday #49 – Orlando and OPASS are proud to announce that there will be a pre-conference seminar...
2010-07-12
780 reads
I had the opportunity to serve on the Program Committee for the 2010 PASS Summit. My job was rating and...
2010-07-08
346 reads
I have few speaking engagements this month that I want to let you know about:
Thursday, July 8 6:00 PM PST...
2010-07-06
599 reads
It’s official! There will be a PASS Conference in the late April or early May in Orlando. Andy Warren (@sqlandy)...
2010-07-01
342 reads
“...And the world is filled with people who can't go to high school, never mind college, and who certainly can't...
2010-06-28
661 reads
It has been awhile since my last post mainly because I was on a working vacation in northern New England...
2010-06-25
465 reads
I'm excited to be presenting Profiling: It's Okay in SQL Server to the Seacost SQL Server Users Group in Portsmouth,...
2010-06-04
305 reads
Planning for SQLSaturday #49 – Orlando is on-going and going well especially since we have a good head start. We have...
2010-05-27
485 reads
After asking members about where the PASS Summit should be located and then deciding to keep it in Seattle for...
2010-05-24
811 reads
Andy Warren (@sqlandy) already blogged about the change here, but I there might actually be someone who reads my blog...
2010-05-19
276 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