Big Data And Hadoop Part 2
In my previous blog I have given more insight on Big Data and now we will take a closer look at...
2012-12-24
446 reads
In my previous blog I have given more insight on Big Data and now we will take a closer look at...
2012-12-24
446 reads
(There is a more up to date version of this script here.
Hey folks, and welcome to my first proper blog post. One of the things that I like to...
2012-12-24
25 reads
One of the simpler pleasures in life is having an idea and putting it up for discussion. Not all ideas...
2012-12-23
914 reads
Today I’ll show you a special script which will let you “take a snapshot” of your table’s data, and apply...
2012-12-23
1,580 reads
Scenario
I have discovered from working on projects that sometimes you may have to make use of temporary or staging tables...
2012-12-23
2,772 reads
Steve Jones sent me a link to this post about Intelligence vs Effort months ago, since then I’ve looked at...
2012-12-22
796 reads
Silver and Gold have a way of really bringing the look and feel of the Christmas season. Silver and Gold also seem to represent something of greater value. We...
2012-12-22
12 reads
Silver and Gold have a way of really bringing the look and feel of the Christmas season.
Silver and Gold also...
2012-12-22
1,264 reads
I wanted to save this link to the Microsoft Support Lifecycle page and thought I’d share as well. It’s a...
2012-12-22
1,182 reads
Tempdb Contention That Can’t be Soothed By Adding Files
Tempdb Contention via Idera diagnostic manager
I’ve talked a lot in the past...
2012-12-21
1,468 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...
Telp/Wa 62817825533 Jl. Dr. Soetomo No.118, Darmo, Kec. Wonokromo, Surabaya, Jawa Timur 60241
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
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