Networking at the PASS Summit: First timers
The PASS Summit is just over a week away, and one again Andy Warren and I are hosting a networking...
2013-10-03
672 reads
The PASS Summit is just over a week away, and one again Andy Warren and I are hosting a networking...
2013-10-03
672 reads
The Stuff We All Get!
Fall has arrived which means it's conference season: Connections is happening this week, the PASS Summit...
2013-10-07 (first published: 2013-10-03)
1,691 reads
I have seen many times at clients where the terms business intelligence and data warehousing are used interchangeably. In reality, these...
2013-10-03
958 reads
I’ve been thinking about a question from a application developer regarding generating a unique identifier outside of SQL and persisting...
2013-10-03
510 reads
I’ve been thinking about a question from a application developer regarding generating a unique identifier outside of SQL and persisting...
2013-10-08 (first published: 2013-10-03)
2,667 reads
Tom Clancy died yesterday. I’ve been reading his books for a long time and I think I’ve read them all...
2013-10-03
490 reads
Yesterday the results were announced, with Jen Stirrup, Tim Ford, and Amy Lewis winning seats for the two year term...
2013-10-03
395 reads
In this article I will show you how to restore a database that is encrypted with Transparent Data Encryption (TDE)...
2013-10-03
1,006 reads
Being part of the database engineering team, we were given a task to setup disaster recovery program for some of...
2013-10-03
766 reads
Below is a script that I use to find the backup history for all the databases on a single instance. There is an inline ‘WHERE’ clause that is currently...
2013-10-03
22 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