SQLSaturday #171 Pittsburgh Prep Continues
Hey, did I mention that Pittsburgh is having a SQLSaturday this year?
Pittsburgh, Pennsylvania. Photo:Herbert Spencer, used under Creative Commons...
2012-07-30
1,578 reads
Hey, did I mention that Pittsburgh is having a SQLSaturday this year?
Pittsburgh, Pennsylvania. Photo:Herbert Spencer, used under Creative Commons...
2012-07-30
1,578 reads
Jen McCown started a #GetHawt set of posts last year and I think it went well. It must have, so...
2012-07-30
1,756 reads
Well well well. It has certainly been a long time between announcements on the blog about meetings for the Las Vegas SQL Server Users Group. We have had to...
2012-07-30
17 reads
Well well well. It has certainly been a long time between announcements on the blog about meetings for the Las...
2012-07-30
1,603 reads
In the same vein as my blog post about Syncing your calendars, I wanted to post how to sync your contacts...
2012-07-30
1,997 reads
Every wonder who all your orphaned SQL Server users are on your server? Just run the script below and copy...
2012-07-30
1,447 reads
This is one of our first PowerPivot video tutorials and this short 1 minute tutorial we show how to enable...
2012-07-30
1,637 reads
Think about a scenario : People are complaining about your production database server.Many users are getting continuous time out error. Rest...
2012-08-01 (first published: 2012-07-30)
3,771 reads
I received an phone call from a friend today asking how to move master and resource system databases in Microsoft...
2012-07-29
6,911 reads
I. Introduction A little while ago, my wonderful wife Renee got a Solid State Drive (SSD) for me. Being a...
2012-07-29
5,708 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