Join me for the 2013 Biml Workshop
Of the many emerging technologies I’m currently using, there’s nothing that excites me more than Biml. If you’re not familiar...
2013-08-21 (first published: 2013-08-14)
1,267 reads
Of the many emerging technologies I’m currently using, there’s nothing that excites me more than Biml. If you’re not familiar...
2013-08-21 (first published: 2013-08-14)
1,267 reads
Working with the SSIS, SSAS, and SSRS Business Intelligence projects along with Database projects in the same Visual Studio 2008...
2013-08-14
2,712 reads
Sometimes it’s the small things that count.
I just noticed two small enhancements to SQL Server 2014's BOL, and I can...
2013-08-14
1,540 reads
I’m setting my course for a new adventure, my mind on a new … undertaking. My apologies if you thought this...
2013-08-14
945 reads
I’ve recently got a request to invoke an executable file from Powershell. Different ways of executing a executable file is given...
2013-08-14
1,150 reads
The other day I found myself in a discussion about media – print, broadcast, and social – and having to explain why...
2013-08-14
873 reads
Few things are more satisfying than to introduce two people when you think they have common interests. Often it’s driven...
2013-08-14
854 reads
Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last...
2013-08-14
1,551 reads
Through Self-Service BI, business units can personalize Business Intelligence to their needs and solve problems at a much faster rate...
2013-08-14
1,070 reads
I have a setup of Central Management Servers in my SQL Server and it’s been a big help to me...
2013-08-14
708 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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