Learning Tree: SQL Server DBA Skills Upgrade
I’m very lucky in my work as freelance consultant and trainer I get to travel the world, and last week...
2012-05-30
2,162 reads
I’m very lucky in my work as freelance consultant and trainer I get to travel the world, and last week...
2012-05-30
2,162 reads
I’ve had a few friends using standing desks for sometime. I first heard about Greg Gonzalez (sqlSentry | Blog | @SQLSensei), fellow...
2012-05-29
1,969 reads
After being forced to deliver sour grapes in my last few columns – thanks to some unexpectedly negative experiences with Oracle...
2012-05-29
1,769 reads
If you haven’t heard yet, Red Gate Software is sponsoring a six city tour of the United States of its...
2012-06-01 (first published: 2012-05-29)
1,804 reads
This week I was building power pivot models for a client pulling data from Oracle. One table kept giving the...
2012-05-29
1,288 reads
Ok folks, you asked for it. Well, a few of you did, anyway. So today I’m going to share with...
2012-05-31 (first published: 2012-05-29)
5,950 reads
It’s been interesting to watch the characters evolve on NCIS over the years, something that can only happen with time...
2012-05-29
859 reads
One of the keys to managing a large production SQL Server environment is being aware of changes that are taking...
2012-06-05 (first published: 2012-05-29)
5,057 reads
Denali – Day 29: Resource Governor Enhancements (Database Engine) Introduction to Resource Governor: Resource Governor is a feature introduced in sql...
2012-05-29
1,672 reads
I got asked a question recently about what books I would recommend for learning T-SQL. I posted a couple months...
2012-05-29
1,134 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