We won vs They Lost
Competitive Sports is one of the incredible miracles to me and I love them greatly. I can watch almost any...
2017-08-29
320 reads
Competitive Sports is one of the incredible miracles to me and I love them greatly. I can watch almost any...
2017-08-29
320 reads
Great. Now you can't even trust your phone's screen, of all things, to not steal your data… https://t.co/KUyGjwsih2 — Adam Machanic...
2017-08-29
402 reads
In this module you will learn how to use the Calendar Custom Visual by Tallan. The Calendar Visual provides a...
2017-08-29
834 reads
Recap
Before we look at “Trusted Assemblies”, let’s take a moment to review the context of the situation. First, the “Good”:...
2017-08-28
1,327 reads
Power BI Report Server August 2017 Preview is now available. Think of this a “v.Next” of Power BI Report Server [On-Premises], for all Data Sources. Here’s an excerpt from...
2017-08-28
15 reads
Power BI Report Server August 2017 Preview is now available. Think of this a “v.Next” of Power BI Report Server [On-Premises], for all Data Sources. Here’s an excerpt from...
2017-08-28
30 reads
Power BI Report Server August 2017 Preview is now available. Think of this a “v.Next” of Power BI Report Server [On-Premises], for all Data Sources. Here’s an excerpt from...
2017-08-28
165 reads
Power BI Report Server August 2017 Preview is now available. Think of this a “v.Next” of Power BI Report Server...
2017-09-12 (first published: 2017-08-28)
3,821 reads
I had two different people ping me on the same day with MySQL questions. One was a former co-worker, asking...
2017-08-28
479 reads
Are you going to be in Florida in November? Me too. I’m privileged to say that I get to speak...
2017-08-28
290 reads
This is my late response to T-SQL Tuesday #204. I almost always forget about...
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...
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