Web Design & Azure
I’ve listened to tons of programmers and DBAs complain about the look of Windows Azure. But, I’m friends with several...
2013-09-20
632 reads
I’ve listened to tons of programmers and DBAs complain about the look of Windows Azure. But, I’m friends with several...
2013-09-20
632 reads
2013-09-20
628 reads
Power Map for Excel 2013 has had some recent enhancements that are worth noting. You can download the latest Power...
2013-09-20
787 reads
Here’s my full presentation for SQL Saturday #250 in Pittsburgh this past Saturday along with some notes on what I...
2013-09-20
961 reads
Before I get too far in the weeds, I have to recognize Rob Collie, his blog (http://www.powerpivotpro.com) and his bookDAX...
2013-09-19
1,734 reads
Every so often I’m reminded that the “basics” aren’t really basics. None of us go to take “How to be...
2013-09-19
713 reads
To make things easier on speakers prior to a SQLSaturday organizers are encouraged to print & cut their SpeedPASSes ahead of...
2013-09-19
1,418 reads
1. SET STATISTICS TIME ON
It not only tell you the compile time of sql command, but also show you the...
2013-09-19
10,262 reads
I first blogged about Power BI for Office 365 two months ago (see Power BI for Office 365) when it was...
2013-09-19
1,094 reads
Red Gate is constantly experimenting with technology. Because of a long history working within the Microsoft space, a lot of...
2013-09-19
829 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