Updated SQL Rockstar Blogger Rankings
This morning, Thomas LaRock (blog|@SQLRockstar) released an updated version of his Blogger Rankings. I was very happy and humbled to...
2012-05-07
1,659 reads
This morning, Thomas LaRock (blog|@SQLRockstar) released an updated version of his Blogger Rankings. I was very happy and humbled to...
2012-05-07
1,659 reads
Introduction
Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly...
2012-05-07
520 reads
The short answer is, of course, none of them, but testing is the only way to be sure.
I was asked,...
2012-05-11 (first published: 2012-05-07)
5,423 reads
Denali – Day 7 : Contained Database
Contained database is another new feature for sql server 2012 – Denali, earlier version has a big...
2012-05-07
1,236 reads
It’s been not quite two years since I moved from a Blackberry to a Droid X. The X turned out...
2012-05-07
548 reads
The first conference I went to back in 1999 I attended every session, the bonus sessions, the breakfasts, everything. It...
2012-05-07
953 reads
It's about three months to to SQLSaturday #158 in NYC, and we're hard at work nailing down all the little...
2012-05-07
1,803 reads
Introduction
Service Broker is a cool new feature since SQL Server 2005. Yes, SQL 2012 just came out so it’s hardly...
2012-05-07
1,709 reads
In Data Quality Services, composite domains can be created to associate together two or more natural domains within a knowledge...
2012-05-07
687 reads
In Data Quality Services, composite domains can be created to associate together two or more natural domains within a knowledge...
2012-05-07
1,213 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...
Jl. Zainul Arifin No.78, Sukoharjo, Kec. Klojen, Kota Malang, Jawa Timur 65118
Jl. Thamrin No.8, Lawang, Kec. Lawang, Kabupaten Malang, Jawa Timur 65211
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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