January OPASS Meeting Recap
On January 20th OPASS was pleased to have had Kevin Kline (Blog|Twitter) from our sponsor, Quest, present 10 Things Every Developer should know. This was the first regular OPASS...
2011-02-04
15 reads
On January 20th OPASS was pleased to have had Kevin Kline (Blog|Twitter) from our sponsor, Quest, present 10 Things Every Developer should know. This was the first regular OPASS...
2011-02-04
15 reads
Some History
Almost exactly 6 years I ago my wife and I decided to apply to be missionaries with New Tribes...
2011-02-03
794 reads
Some History Almost exactly 7 years I ago my wife and I decided to apply to be missionaries with New Tribes Mission. We decided at that time to...
2011-02-03
12 reads
January’s OPASS meeting will be held this Thursday, January 20th at 6pm. We will be meeting at the Hampton Inn,...
2011-01-18
616 reads
January’s OPASS meeting will be held this Thursday, January 20th at 6pm. We will be meeting at the Hampton Inn, 850 Village Oak Lane, Lake Mary. SQL Server...
2011-01-18
14 reads
Congratulations to the winners in the Professional Development Track Vote for PASS SQLRally. You can see the winners at http://www.sqlpass.org/sqlrally/2011/Agenda/Sessions/SessionsProfessionalDevelopment.aspx.
Now the...
2011-01-18
791 reads
Congratulations to the winners in the Professional Development Track Vote for PASS SQLRally. You can see the winners at http://www.sqlpass.org/sqlrally/2011/Agenda/Sessions/SessionsProfessionalDevelopment.aspx. Now the voting is open for the Database &...
2011-01-18
19 reads
I’ll be speaking at SQLSaturday #62 – Tampa this Saturday, January 15th. I’ll be presenting:
Why I Use Stored Procedures
With the proliferation...
2011-01-10
775 reads
I’ll be speaking at SQLSaturday #62 – Tampa this Saturday, January 15th. I’ll be presenting: Why I Use Stored Procedures With the...
2011-01-10
16 reads
I recently had a friend contact me recently to ask for some help with TSQL. The basic issue is that...
2011-01-06
1,062 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