Sharing the Love
Just a few blog posts that you ought to go and read.
First up, Tom LaRock maintains a listing of SQL...
2012-11-30
1,692 reads
Just a few blog posts that you ought to go and read.
First up, Tom LaRock maintains a listing of SQL...
2012-11-30
1,692 reads
I've been extoling the Rules of Holes, hoping to give you both courage to get out of your Hole, and...
2012-11-30
1,537 reads
As well as creating the script for yesterday’s post on finding Tables without a Clustered Index I tweaked the script...
2012-12-06 (first published: 2012-11-30)
5,255 reads
This is my first time attending a SQL Saturday event and I’m quite excited. If you live in or near...
2012-11-30
1,226 reads
I’m very excited to announce that you can now purchase my latest release book:Knight’s Microsoft SQL Server 2012 Integration Services...
2012-11-30
3,335 reads
This is a quick rewrite of the script I just posted a few days ago. The script had a few flaws if trying to run it on a SQL...
2012-11-30
33 reads
This is a quick rewrite of the script I just posted a few days ago. The script had a few...
2012-12-04 (first published: 2012-11-30)
2,527 reads
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-11-29
2,458 reads
I’m gathering a few metrics around the Internet for SQL Server from people that I think really know how to...
2012-12-07 (first published: 2012-11-29)
3,002 reads
As exciting as SQL Server 2012 is, with its multitude of new features, it’s not always possible to upgrade right...
2012-11-29
2,850 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