Recharging Again
I’m off again, taking a week in Steamboat Springs with my family for the Christmas holiday. We’re spending a week...
2012-12-21
920 reads
I’m off again, taking a week in Steamboat Springs with my family for the Christmas holiday. We’re spending a week...
2012-12-21
920 reads
This may not be the coolest thing in the world, but it is quite useful. From the annals of Books...
2012-12-21
666 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-12-21
908 reads
So, you may have noticed that things have been a little quiet around here of late. Sorry about that, I’ve...
2012-12-21
827 reads
Hello Dear Reader! I've been working on Setting up a Virtual Lab in using Virtual Box on my work laptop....
2012-12-21
1,508 reads
Creating a custom data collector can be very handy for a DBA. Especially in times of troubleshooting. These collectors are also quite useful for trending and analysis. Consider this...
2012-12-21
27 reads
It’s the end of the world as we know it. And as the song goes…I feel fine! But hey, we...
2012-12-21
1,238 reads
Thanks to everyone who attended my “Introduction to Microsoft’s Master Data Services (MDS)” for the Data Architecture Virtual Chapter. The recording...
2012-12-21
1,184 reads
Purpose and introduction A Python program will not be able to take advantage of more than one core or more...
2012-12-21
4,782 reads
All the videos for the sessions at PASS SQLRally Nordic 2012 are available for free. Lot’s of great BI info. Check...
2012-12-20
901 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 628217555651 Jl. Raya Darmo No.5, Keputran, Kec. Tegalsari, Surabaya, Jawa Timur 60265
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...
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