Notes from SQLSaturday #227 in Charleston
My first time in Charleston! Quick notes:
Made the drive with the family in 7 hours, not bad, and easily the...
2013-10-13
568 reads
My first time in Charleston! Quick notes:
Made the drive with the family in 7 hours, not bad, and easily the...
2013-10-13
568 reads
Partitioning is a feature that has been around since SQL Server 2005. It allows for users to split a table...
2013-10-12
2,702 reads
In less than 72 hours I'll be in Charlotte with over 3,000 of my closest SQL Server friends for the...
2013-10-11
721 reads
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-11
613 reads
It’s Friday. Tomorrow I present two sessions at SQL Saturday #238 – Minnesota. Then I take off for PASS Summit 2013...
2013-10-11
726 reads
I’m not old, but I did turn 40 today. If you ask my kids, they are likely to say that...
2013-10-11
813 reads
For those of you that attended yesterday and are interested in the slides, you can download them here. Thanks! Topic:...
2013-10-11
748 reads
This sort of ties in to my last post on denying reality.
Managing expectations is the most important thing to success...
2013-10-11
704 reads
The SQL Crazy train continues chugging along this month. The next two whistle stops are back to back in the Carolinas. The first stop is coming up in just...
2013-10-11
15 reads
The SQL Crazy train continues chugging along this month. The next two whistle stops are back to back in the...
2013-10-11
669 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