Mastering Reporting Services Expressions, March 26
As part of SQL Server Pro eLearning series, I’ll be presenting three 75 minute sessions on March 26th on using...
2013-03-15
800 reads
As part of SQL Server Pro eLearning series, I’ll be presenting three 75 minute sessions on March 26th on using...
2013-03-15
800 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-03-15
718 reads
Do you work for US Education? Are you interested in Learning about Microsoft BI? If so, please join me as...
2013-03-15
1,278 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-03-15
1,187 reads
When developing and debugging transport security WCF services it’s a real pain if each developer on the team needs to...
2013-03-15
224 reads
I recently had to rename my laptop on which I have two SQL server instances. I have a default instance...
2013-03-14
1,703 reads
While I was at the 2011 Pass Summit I was given the following piece of code to create a comma...
2013-03-14
912 reads
This is a short series on some customizations in SSMS to make it visually more appealing.
As a presenter, I’ve learned...
2013-03-14
1,164 reads
A table can have only one clustered index as the data rows are stored in the order of the clustered...
2013-03-14
30,653 reads
I have been doing some work on the Modern Apps Live! content that required me to use both an Office365...
2013-03-14
803 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