TechEd North America 2013 videos online
Microsoft has posted ALL the session videos for TechEd North America 2013 and they are available for free! What a...
2013-06-20
801 reads
Microsoft has posted ALL the session videos for TechEd North America 2013 and they are available for free! What a...
2013-06-20
801 reads
I’m going to get slammed for the title by someone but I stand by it. First some definitions.
Disaster Recovery...
2013-06-20
947 reads
A user calls to say the app or server is slow today. Here’s a quick summary of how I get...
2013-06-20
881 reads
Thanks everyone for attending my free webinar on Creating Real World PowerPivot Models on June, 18, 2013. If you were...
2013-06-20
1,057 reads
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-20
1,049 reads
In the ever changing landscape that is Business Intelligence (or is that Business Analytics?), a fellow business analyst from Magenic,...
2013-06-19
928 reads
I recently composed an email (on the side) for a client DBA looking for info on getting involved with the...
2013-06-19
522 reads
It’s not too uncommon for a query to get a new execution plan that performs a lot worse than it...
2013-06-24 (first published: 2013-06-19)
1,815 reads
I got a special recognition from Microsoft, India as one of the top community leaders.
My sincere thanks to SQLServerCentral (my...
2013-06-19
1,343 reads
To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL...
2013-06-19
916 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