SQL Server 2012 and summertime in London
The week just passed I have been teaching Learning Tree course 2108 SQL Server 2012 Database Administration in London. It...
2012-07-23
1,023 reads
The week just passed I have been teaching Learning Tree course 2108 SQL Server 2012 Database Administration in London. It...
2012-07-23
1,023 reads
In the last blog posting about AlwaysOn you have seen how you can deploy your first
Availability Group through the AlwaysOn...
2012-07-25 (first published: 2012-07-23)
7,147 reads
It’s been a great day for British cycling with Bradley Wiggins becoming the first Briton to ever win the Tour...
2012-07-22
1,133 reads
Presentation and scripts from my Storing PowerShell Output session at South Florida IT Pro Camp 2012.
2012-07-22
1,125 reads
I have recently been notified that my neighboring SQL PASS Chapter Atlanta MDF will be sponsoring SQL Saturday 167 in...
2012-07-22
570 reads
In previous lessons we create basic PowerPivot model now it is time to see how it looks in Excel 2013...
2012-07-22
1,278 reads
We continue creating our PowerPivot model using Excel 2013 by adding relationships. We use two methods "manage relationships" dialog box...
2012-07-22
915 reads
In this tutorial we start creating PowerPivot model in Excel 2013 (very similar in 2010) by importing data from our...
2012-07-22
1,154 reads
I saw Ami Levin at the PASS Summit 2011 presenting on Loop Iterators in Execution Plans. It was on my...
2012-07-22
842 reads
WordPress creates a unique link for each of your post. They are broken out with your URL then YYYY / MM...
2012-07-22
638 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