SQL Saturday Orlando: LAST CALL for Speakers
Hello Dear Reader! I just wanted to write to Thank All of you for the submissions to SQL Saturday 232...
2013-07-05
768 reads
Hello Dear Reader! I just wanted to write to Thank All of you for the submissions to SQL Saturday 232...
2013-07-05
768 reads
Ok, before I continue to next step, I really want to put down something about it. Especially about ‘how to...
2013-07-03
9,177 reads
I was thinking back fondly of my Dad - who passed away during Hurricane Sandy - this past Father's Day. Of the...
2013-07-03
572 reads
Sometimes we try an do things that just shouldn’t work. Maybe they aren’t supported or there technology isn’t designed for...
2013-07-03
1,232 reads
In the last post, we have discussed about the auto create and auto update property of the statistics. Do we really need to do manual statistics maintenance to keep...
2013-07-03
73 reads
In the last post, we have discussed about the auto create and auto update property of the statistics. Do we...
2013-07-09 (first published: 2013-07-02)
4,949 reads
This was my first time attending the AAW Symposium, hosted by the American Association of Woodturners. Here are some quick...
2013-07-02
790 reads
1. 3004
show the internal backup/restore operation for every step.
ex.
dbcc traceon(3004,3605,-1)
GO
3605 means output the message to errorlog. you can use 3604...
2013-07-02
4,671 reads
I’m very excited to see my first feature article published in SQL Server Pro Magazine titled Custom Programming to Enhance...
2013-07-02
922 reads
Wow!
You’d think that an event might get a little worn by the third time you’re doing it. That maybe it...
2013-07-02
732 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