Speaker Selection for SQLSaturday Orlando–More!
More speakers from Florida! Scott Klein lives in Seattle now, but we still consider him an honorary Floridian according to...
2012-07-15
653 reads
More speakers from Florida! Scott Klein lives in Seattle now, but we still consider him an honorary Floridian according to...
2012-07-15
653 reads
2012-07-15
1,153 reads
Introducing Windows Server 2012 - can be downloaded for free here.
This book provides the early, high-level information you need to begin preparing...
2012-07-14
2,278 reads
We’re drawing to the end of our third season of DBAs@Midnight (our weekly webshow by DBAs, for DBAs), and to the...
2012-07-13
761 reads
I bought a USB hard disk recently that I wanted to use to backup some VMware Workstation and some Hyper-V...
2012-07-13
1,011 reads
Not another comma separated string blog post I hear you say! I know that this topic has probably been done...
2012-07-13
6,850 reads
18456 is probably one of the most common errors people come across and in this article we try to cover...
2012-07-13
804 reads
Fujitsu has submitted a new TPC-E benchmark for a two socket, Sandy Bridge-EP system that had a tpsE score of...
2012-07-13
1,954 reads
As a DBA, it is important for all of us to get real time alert on various issues in our...
2012-07-13
6,761 reads
Last few month I was really busy and had completely no time for SQLTreeo. This add-in was started being used by...
2012-07-12
835 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