Installing SQL Server 2012 on Windows Server 2012
Everyone knows that installing SQL server requires .Net frameworks 3.5, and it normally install by default, when you run the...
2013-03-12
621 reads
Everyone knows that installing SQL server requires .Net frameworks 3.5, and it normally install by default, when you run the...
2013-03-12
621 reads
Another month and we have another installment (meeting) for the Data Professionals of the Las Vegas area. This month we will be getting back on schedule with the usual...
2013-03-11
11 reads
Another month and we have another installment (meeting) for the Data Professionals of the Las Vegas area.
This month we will...
2013-03-11
907 reads
Every week, Pragmatic Works offers up its “Training on the Ts” webcast series and this month, in honor of Women’s History Month,...
2013-03-11
576 reads
This weekend was full of a range of emotions for me. Grab a beverage and I’ll tell you all about...
2013-03-11
872 reads
I blogged about this back in September of 2010, but technology changes so it’s time to revisit this again. Now...
2013-03-11
949 reads
Were you ever asked to generate string Permutations using TSql? I was recently asked to do so, and the logic...
2013-03-11
911 reads
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-03-11
566 reads
I’m happy to announce that I’ll be doing a tour of the 4 SQL Server user groups in central Colorado...
2013-03-11
692 reads
With the motherboard and CPU installed I was ready to add the final and perhaps easiest parts to the build....
2013-03-11
664 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