The Best High Availability
Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.
2009-04-28
725 reads
Clustering is often the first choice for high availability, but is it the best choice? A lot of people think so, but Steve Jones has other thoughts.
2009-04-28
725 reads
A licensing scheme from Embarcadero catches Steve Jones' eye. He comments on a great way for the company to work with customers.
2009-04-27
116 reads
This week Steve Jones discusses ethics and leadership in IT.
2009-04-27
122 reads
The person responsible for your career is you. Steve Jones gives you a few thoughts on how you might approach your career.
2009-04-22
438 reads
With the economy in a downturn, Steve Jones talks about what you might want to do to be pro-active with your projects.
2009-04-21
118 reads
Steve Jones takes a minute today to congratulate Brian Knight and the Pragmatic Works Foundation for their efforts in giving back to the community.
2009-04-20
92 reads
Steve Jones ends a "Week in the Clouds" with a poll asking if you might have changed your mind about using a cloud version of SQL Server.
2009-04-17
280 reads
Day four of a "Week in the Clouds" has Steve Jones dreaming of some exciting possibilities for SQL Server and cloud computing.
2009-04-16
299 reads
Continuing on with a "Week in the Clouds", today Steve Jones discusses some of the challenges of cloud computing.
2009-04-15
566 reads
Continuing on with his week in the clouds, Steve Jones looks at how SQL Server might appear in the cloud world.
2009-04-14
298 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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