A Month of PowerShell – Day 13 (Databases: Adding Schemas, Tables and Indexes)
Welcome to Day 13 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-20 (first published: 2013-02-13)
2,969 reads
Welcome to Day 13 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-20 (first published: 2013-02-13)
2,969 reads
Since September 2012 I’m a Microsoft Certified Master SQL Server 2008, which is the highest technical certification for SQL Server...
2013-02-13
824 reads
Since September 2012 I'm a Microsoft Certified Master SQL Server 2008,
which is the highest technical certification for SQL Server that...
2013-02-13
1,054 reads
Thanks to everyone who attended my presentation “Introduction to Microsoft’s Master Data Services (MDS)” at the Houston Area SQL Server User Group...
2013-02-13
1,908 reads
This Wednesday I will be presenting for the PASS Virtualization Virtual Chapter at 11AM CST on one of my favorite...
2013-02-13
678 reads
by Steve Bolton
In last week’s installment of this amateur series of self-tutorials on SQL Server Data Mining (SSDM), we...
2013-02-19 (first published: 2013-02-12)
3,332 reads
This blog post is part of T-SQL Tuesday, a monthly SQL blog party with a rotating host and common topic....
2013-02-12
2,073 reads
Update: The President’s cybersecurity Executive Order was signed and released today (see the Wired article). “Although the order comes after...
2013-02-12
867 reads
This month the invitation is from Wayne Sheffield, asking if you have a PowerShell story for everyone. That’s fitting since...
2013-02-12
1,017 reads
This month, Wayne Sheffield (Blog | @DBAWayne) is running T-SQL Tuesday on PowerShell. T-SQL Tuesday is a monthly blogging event where a number...
2013-02-12
725 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