Growing PASS Step One - Communication
My History with PASS
Over the last two years I have become more involved in the SQL Server community through attending...
2010-04-20
650 reads
My History with PASS
Over the last two years I have become more involved in the SQL Server community through attending...
2010-04-20
650 reads
After having a bit of a tough time in the April OPASS meeting (read about it here), due to not...
2010-04-15
311 reads
Well, we had our April meeting on Tuesday the 13th. Let's just say it wasn't our most successful meeting, and...
2010-04-14
485 reads
Aaron Nelson (@SqlVariant) is hosting this month’s T-SQL Tuesday (#tsql2sday) and his topic is reporting.
One of the frustrations I have...
2010-04-13
1,815 reads
Tomorrow night, April 13th, at 6pm we will be having our April OPASS meeting, sponsored by Veredus Orlando with Joe...
2010-04-12
452 reads
Believe it or not, it's already time to start planning for Orlando's next SQLSaturday. Andy Warren and I had our...
2010-04-07
432 reads
Steve Jones’ (@way0utwest) recent SQLServerCentral editorial, The Missing Certification, has spawned a vigorous debate about what the missing certification should...
2010-04-01
1,435 reads
So the other day I posted, Slipstream - Makes installs simple, and this afternoon I needed to do a SQL Server...
2010-03-30
1,407 reads
I was recently working on building a test environment for myself while I was studying for the MCITP-Database Administration exams. ...
2010-03-29
1,572 reads
This is not a technical or SQL Server post, but it does illustrate the power of networking.
We recently took my...
2010-03-24
522 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