Sorry, Mikko, the box was already open
In a blog post F-Secure's Chief Research Officer, Mikko Hypponen (blog | twitter), indicated that with the US participating in cyberattacks...
2012-06-11 (first published: 2012-06-05)
2,404 reads
In a blog post F-Secure's Chief Research Officer, Mikko Hypponen (blog | twitter), indicated that with the US participating in cyberattacks...
2012-06-11 (first published: 2012-06-05)
2,404 reads
Hi,
Yesterday I delivered a session on Parallel Processing at the Israeli User Group.
I had a great time and hope you...
2012-06-05
336 reads
Disclaimer: I wrote this review as a participant to O’Reilly Blogger Review Program.
If you’ve never seen a programming code in...
2012-06-05
1,087 reads
It’s the first Monday of the month, have you checked your servers out? Do you know that everything with your...
2012-06-08 (first published: 2012-06-04)
2,451 reads
This will be my fourth trip to Pensacola for SQL Saturday #132. I’ve enjoyed going every time and I usually...
2012-06-04
973 reads
Microsoft SQL Server Master Data Services (MDS) is a Master Data Management (MDM) product from Microsoft. Master Data Services is...
2012-06-08 (first published: 2012-06-04)
20,660 reads
Is it just me, or does there seem to be a lot of discussion these days about testing backups and...
2012-06-04
1,538 reads
While presenting this weekend at SQL Saturday #117 in Columbus, OH (great event, if you missed it, you missed it),...
2012-06-07 (first published: 2012-06-04)
3,351 reads
A database server should be able to service requests from a large number of concurrent users. When a database server...
2012-06-04
3,402 reads
What do we do? Have you ever run into a database that is in the “In Recovery” state? If that has happened, have the bosses and/or endusers come to...
2012-06-04
18 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