I’m Voting for Allen Kinsel
As you can see from the title of this post, I’ve decided on one of the three votes I’ll be...
2013-09-25
765 reads
As you can see from the title of this post, I’ve decided on one of the three votes I’ll be...
2013-09-25
765 reads
Couple of months back(To be specific in June) Microsoft and Oracle announced their partnership to help enterprise customers embrace the...
2013-09-24
979 reads
Find a useful system store procedure to list all mapping user of SQL login account.
sp_msloginmappings @Loginname , @Flags
@loginname: the login account name, If...
2013-09-27 (first published: 2013-09-24)
9,908 reads
As you may have seen in my post yesterday “PASS Board of Directors Election: Candidates announced” I am running for...
2013-09-24
753 reads
Hello Dear Reader! We are finishing up the final day of the Performance Tuning Workshop here in Atlanta and I...
2013-09-26 (first published: 2013-09-24)
7,543 reads
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-09-24
1,202 reads
As you may have seen in my post yesterday “PASS Board of Directors Election: Candidates announced” I am running for...
2013-09-24
713 reads
Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM). Below is a...
2013-09-24
1,467 reads
One of the things that can make Windows Azure SQL Databases (WASD) attractive is the fact that they run inside...
2013-09-24
779 reads
Tim Ford is running for a seat on the PASS Board of Directors and has my vote. Yes I think...
2013-09-24
609 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