DBAs and the Dark Closet
For many years, I loved being a DBA because, unlike being a developer, I could sort of hide from the...
2013-02-06
1,037 reads
For many years, I loved being a DBA because, unlike being a developer, I could sort of hide from the...
2013-02-06
1,037 reads
The email message earlier today said “Please note that the official schedule will be released tomorrow, February 6th, so please...
2013-02-06
693 reads
This is the second part of the three part article series on partitioning relational data.
In the first part of this...
2013-02-05
718 reads
Last week I noted that I was speaking at the new SQL Intersection event. Hopefully I’ll see some of you...
2013-02-05
892 reads
Here is the February 2013 version of my SQL Server 2008 R2 Diagnostic Information Queries, with some minor tweaks and...
2013-02-05
1,169 reads
If you are familiar at all with Visual Studio Live! then you should check out this new conference. At the...
2013-02-05
604 reads
My experience installing Team Foundation Server (TFS) 2012 to house my business intelligence projects built in Visual Studio 2010:
I am installing...
2013-02-05
6,033 reads
Welcome to Day 5 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-05
1,668 reads
T-SQL Tuesday Party History
In case you’ve been hiding out in the desert, oblivious to all that goes on, there is...
2013-02-08 (first published: 2013-02-05)
1,570 reads
I recieved an email today from my publisher Joes 2 Pros that my book was now available on Barnes and...
2013-02-05
546 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