Disable the Charms Bar – Making Windows 8 Better
One of the things that’s bothered me is the way the charms bar frequent popping out as my mouse moves...
2013-07-17
968 reads
One of the things that’s bothered me is the way the charms bar frequent popping out as my mouse moves...
2013-07-17
968 reads
Most of the time we have been used to cmdlets and it’s various features but do not know about the...
2013-07-17
1,435 reads
It’s done, finally! The sessions for SQLSaturday #232 have been selected and the schedule is available for viewing. We have...
2013-07-17
699 reads
On July 10th 2013, I gave a presentation with the Professional Association for SQL Server (PASS) DBA Fundamentals Virtual Chapter....
2013-07-17
634 reads
The PASS Security virtual chapter is up and running thanks to the hard work of Argenis Fernandez (blog | twitter) and...
2013-07-17
1,275 reads
Performance tuning is one of the important task of DBA. Many times people comes to us with different types of performance issue.To handle all these, we should have...
2013-07-17
61 reads
Hello Dear Reader! Just a quick blog post today. The Schedule for SQL Saturday 232 is now live! You probably...
2013-07-16
556 reads
Performance tuning is one of the important task of DBA. Many times people comes to us with different types of...
2013-07-24 (first published: 2013-07-16)
4,029 reads
Why do companies use placement firms to find IT contractors instead of using internal recruiters?
Who better to answer that question...
2013-07-16
803 reads
In a previous post we’ve seen how to share the SQL Prompt snippet folder to the development team. We’ve used dropbox for sharing...
2013-07-16
1,020 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