Update duplicate xml attribute values to unique value
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I’m not sure why...
2016-06-23
23 reads
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love finding creative solutions in XQuery, I’m not sure why...
2016-06-23
23 reads
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love...
2016-06-23
557 reads
I was going through some really old blogging ideas and I stumbled over this one and seeing as I love...
2016-06-23
1,121 reads
I love Azure and I love PowerShell. They are a perfect marriage. It’s amazing how much automation you can do...
2016-06-23
552 reads
Another Twitter-born blog post! I love getting new ideas from the community. Real world ideas for solving real world problems!
The...
2016-06-23
1,291 reads
This is a series of posts on the PASS Summit and SQL Saturdays. I’m outlining some thoughts here, sometimes for...
2016-06-23
499 reads
The pricing for Azure SQL Data Warehouse (SQL DW) consists of a compute charge and a storage charge. For compute, it is...
2016-06-23
933 reads
I’m excited to announce that I have been selected to speak at PASS Summit again this year! I’ll be presenting...
2016-06-23
351 reads
I’ve had a lot of luck in my career, especially as it pertains to my work environment. Although I can’t...
2016-07-01 (first published: 2016-06-23)
2,047 reads
Another Twitter-born blog post! I love getting new ideas from the community. Real world ideas for solving real world problems!
The...
2016-06-23
333 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