1h SSIS Webinar
1h Free SSIS Webinar - 7th of Feb 2013
We recently submitted a session for SQL Bits and SQL Saturday (UK) and...
2013-01-14
731 reads
1h Free SSIS Webinar - 7th of Feb 2013
We recently submitted a session for SQL Bits and SQL Saturday (UK) and...
2013-01-14
731 reads
Recently, one of my favorite customers asked me some very thought-provoking questions about using database partitioning to move transactional data around. Their...
2013-01-18 (first published: 2013-01-14)
15,049 reads
If you’ve been working with the Azure SQL Database portal, you know that you have a query window. Within the...
2013-01-16 (first published: 2013-01-14)
1,867 reads
This isn’t really one of those features of SSMS that I’ve used a great deal. At least didn’t until recently....
2013-01-17 (first published: 2013-01-14)
3,313 reads
Hey Friends,
Let’s today discuss on the topic How search works. We have already discussed the crawling concept in previous blog:
How...
2013-01-14
709 reads
Page navigation can be a pain to achieve in a true MVVM way, I recently ran in to this problem...
2013-01-14
98 reads
Key Performance Indicators (KPIs) are measurements used to gauge business performance against quantifiable goals. SQL Server Analysis Services provides functionality...
2013-01-15 (first published: 2013-01-14)
6,600 reads
31 Days of Disaster Recovery
Fittingly, today’s focus on disaster recovery as part of my 31 Days of Disaster Recovery...
2013-01-12
1,350 reads
Here is the January 2013 version of my SQL Server 2008 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-01-12
904 reads
Here is the January 2013 version of my SQL Server 2012 Diagnostic Information Queries, with some minor tweaks and improvements...
2013-01-12
911 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