How to write understandable code for your future self
This story originally appeared in Hacker Noon on February 10, 2017.
I can't tell you the number of times the title of this post has crossed my mind as I...
2017-04-18
28 reads
This story originally appeared in Hacker Noon on February 10, 2017.
I can't tell you the number of times the title of this post has crossed my mind as I...
2017-04-18
28 reads
This summer I’m going to try something a little different. I’ll be speaking at a technology conference that is not...
2017-04-18
381 reads
I am honored to be a Guest Blogger at SQLPerformance.com. As a member of the SentryOne Product Advisory Council (PAC)...
2017-04-18
379 reads
Thoughts on how to think about parallelism in SQL Server - and how to tune it.
2017-04-18
24 reads
In February 2017, Microsoft announced the general availability of Blob Auditing for Azure SQL Database. While auditing features were available...
2017-04-18
657 reads
In this module you will learn how to use the Line Dot Chart Power BI Custom Visual. The Line Dot...
2017-04-26 (first published: 2017-04-18)
1,420 reads
I asked the SQL Server community to write about their experience/opinion about the changing world we live in and how...
2017-04-18
431 reads
Hello!
So, on another blog a long time ago, I wrote a couple of posts about foreign keys and what step...
2017-04-18
137 reads
In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica to availability group. This error mostly appears when we...
2017-04-18
28 reads
In this post, I’m going to talk an issue that I found when joining replica or database on secondary replica...
2017-04-18
1,738 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...
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