TechEd Europe 2013 videos online
Microsoft has posted ALL the session videos for TechEd Europe 2013 and they are available for free! Some great videos...
2013-07-25
875 reads
Microsoft has posted ALL the session videos for TechEd Europe 2013 and they are available for free! Some great videos...
2013-07-25
875 reads
So this week was another first for me, I finally bit the bullet and gave a talk at the Leeds...
2013-07-25
788 reads
I’m not terribly good at putting at least one image in every post. The images I do use are either...
2013-07-25
951 reads
Whilst doing some ad-hoc work on some data on a 2012 SP1 instance I came across an issue with the...
2013-07-25
1,386 reads
This topic is part of the lessons covered in Optimization and Troubleshooting SQL Server 2012 which is 14% of overall...
2013-07-25
1,857 reads
TODAY, JULY 25: the NYC SQL Server User Group is honored to have a visiting SQL Server MVP all the...
2013-07-25
1,237 reads
In the last post , we have discussed about the Differential Change Map pages and how it is utilized in the differential backup process.In this post, let us try to...
2013-07-25
52 reads
I recently encountered a DBCC CHECKDB failure with a fairly non-specific failure message. The error message said it terminated abnormally...
2013-07-24
7,245 reads
In the last post , we have discussed about the Differential Change Map pages and how it is utilized in the...
2013-07-24
3,782 reads
I’ve never really used the F1 key for help files with most applications. I was surprised at the usefulness in...
2013-07-24
881 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