More on Strengthfinders
This past week I attended a one hour facilitated group session that was a continuation of the Strengthfinders assessment. One...
2016-08-02
449 reads
This past week I attended a one hour facilitated group session that was a continuation of the Strengthfinders assessment. One...
2016-08-02
449 reads
One of the things that people don’t think about often is whether the changes made in development actually get to...
2016-08-02
886 reads
By Steve Bolton
…………Taking the dive into fuzzy sets immediately elicits the obvious question: just how fuzzy is the data we’re...
2016-08-02
872 reads
More of the same with the next Expert Performance Indexing for SQL Server book giveaway. So far, I’ve sent out six copies of the book based on comments from the past six (1, 2,...
2016-08-01
36 reads
More of the same with the next Expert Performance Indexing for SQL Server book giveaway. So far, I’ve sent out six copies of...
2016-08-01
823 reads
In this module you will learn how to use the Card with States Power BI Custom Visual. The Card with...
2016-08-01
1,223 reads
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to...
2016-08-01
16 reads
It’s Monday and time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me...
2016-08-01
887 reads
Update: As Gerhard points out in the comments, switching to ORC files solves this issue nicely. It’s not human readable,...
2016-08-09 (first published: 2016-08-01)
2,158 reads
I actually saw the above statement posted online. The person making the claim further stated that choosing between these three constructs was “personal...
2016-08-01
1,416 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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