Speaker of the Month: August 2014
Speaker of the Month is now officially one year old.
I went back and reread my first post. The goals were...
2014-08-08 (first published: 2014-08-01)
7,059 reads
Speaker of the Month is now officially one year old.
I went back and reread my first post. The goals were...
2014-08-08 (first published: 2014-08-01)
7,059 reads
Few things have more impact on our career than job titles. The job titles we’ve held tell future employers a...
2014-08-08
515 reads
After my review of Tableau Dashboard Cookbook, I read another book about Tableau, namely Tableau Data Visualization Cookbook by Ashutosh...
2014-08-08
1,089 reads
As always, there are many free ways to learn more about SQL Server and the Professional Association of SQL Server...
2014-08-08
688 reads
All the videos for the sessions at 24 Hours of PASS (Spring 2014) are available for free. Check the session schedule for...
2014-08-07
1,268 reads
Coming up on my schedule is another appearance at SQL Saturday Orlando. Orlando is quite special to me as it...
2014-08-07
695 reads
I’m proud to announce that yesterday the first installment of my new Stairway series at SQL Server Central has been...
2014-08-07
1,040 reads
Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes...
2014-08-07 (first published: 2014-07-30)
9,442 reads
One of the better graphics I’ve seen in a Connector that shows the timeline:
My thoughts:
Should You Run for the...
2014-08-06
752 reads
As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...
2014-08-06 (first published: 2014-07-29)
8,139 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