Don Gabor Presents Mastering the Art of Conversation and Making Business Contacts in NYC
My friend Don Gabor is presenting a two hour seminar titled “Mastering the Art of Conversation and Making Business Contacts”...
2013-02-09
776 reads
My friend Don Gabor is presenting a two hour seminar titled “Mastering the Art of Conversation and Making Business Contacts”...
2013-02-09
776 reads
I’m planning to attend SQLSaturday #200 in Philadelphia on June 1, 2013. Number 200! This will be my first trip...
2013-02-09
609 reads
This post is a quick tip to find the version of Windows Installer installed on your box.
You might wonder why...
2013-02-09
1,222 reads
I will be speaking at the PASS Database Administration Virtual Chapter on February 13, 2013 at 12PM MST. I will...
2013-02-09
808 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-02-08
1,384 reads
I have been working with a client recently who purchased a nice top of the line de-duplication backup device in...
2013-02-08
1,092 reads
What is Inquire
The Inquire Add-in for Excel 2013 helps you analyze and review your workbooks for things like relationships, invalid...
2013-02-08
2,281 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-08
905 reads
One of the great features available since SQL 2008 is Row and/or Page Compression. However, even for those of you on SQL...
2013-02-08
2,795 reads
Welcome to Day 8 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-08
707 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