Happy Halloween! A TALE OF THE SCARY DBA! - Reblog
Today, October 31, 2013 is Halloween, and in the spirit of the holiday of ghosts, goblins, vampires, werewolves, witches and...
2013-10-31
2,007 reads
Today, October 31, 2013 is Halloween, and in the spirit of the holiday of ghosts, goblins, vampires, werewolves, witches and...
2013-10-31
2,007 reads
In my day to day operations I have the opportunity to work with people in various capacities in regards to data. Sometimes it is in the capacity of a...
2013-10-31
14 reads
In my day to day operations I have the opportunity to work with people in various capacities in regards to...
2013-10-31
1,246 reads
I'm trying to re-establish this running guide to free online training for the following week. If you're a training provider...
2013-10-31
3,372 reads
Introduction
A few days ago, a friend of mine approached me with an interesting challenge. What he was trying to achieve...
2013-10-30
2,025 reads
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando. Those rather nice folks at SQL Server Live are also offering SQL Brit...
2013-10-30
22 reads
This is a quick post to announce the winner of our competition for a FREE conference pass to SQL Server Live! in Orlando.
Those rather nice...
2013-10-30
1,378 reads
I’ll be heading back to Tampa on November 9, 2013 for the BI Edition of SQLSaturday. I’ll be presenting PCI...
2013-10-30
1,206 reads
Rick Bolesta and Neil Buchwalter of CA technologies are leaving the Board at the end of 2013. CA and Microsoft...
2013-10-30
1,434 reads
There are lots of ways to learn new things, or be reminded of old things. One of my favorites is...
2013-11-05 (first published: 2013-10-30)
5,196 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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