Down and Dark
I came back from vacation to find the home DSL line bouncing up and down a bit. I wasn’t overly...
2012-06-26
1,573 reads
I came back from vacation to find the home DSL line bouncing up and down a bit. I wasn’t overly...
2012-06-26
1,573 reads
This will be the easiest entry in this series. This is a reblog of an article I wrote last year....
2012-06-26
1,186 reads
We here in the IT community are clearly concerned about our weight. More specifically, we’re concerned about our weight going...
2012-06-26
973 reads
First off, I apologize. As if writing a book wasn’t hard enough, now we get new problems because of on-demand...
2012-06-26
845 reads
With Snapshot (read committed snapshot and snapshot isolation level) enabled, when data reading on a table takes place, if any...
2012-06-26
2,801 reads
I avoid politics here, a discussion best done in other places, but hope you’ll enjoy some thoughts about a recent...
2012-06-26
802 reads
The Nordic SQL Server event of the year is getting closer and closer. YES it is SQL Rally Nordic that...
2012-06-26
899 reads
Back in May, I had a conversation with a sql friend in the community, and well, my friend (who I...
2012-06-26
1,460 reads
I’ll be honest, I contemplated a lot about whether to write this blog or not for fear that it may...
2012-06-26
290 reads
The PASS Summit 2012 schedule has been released, and I’m proud to announce that I’ve been selected to present a...
2012-06-25
691 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