PowerShell Virtual Group of PASS January Newsletter
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re...
2017-01-18
530 reads
We spend way too much time each month drafting the newsletters for the PowerShell Group of PASS. But hey, we’re...
2017-01-18
530 reads
Blocking is just part of life I’m afraid. Because we have locks (and yes we have to have them, and...
2017-01-18
3,224 reads
From request to delivery in 5 minutes or less! xSQL RSS Reporter for SQL Server enables you to generate standard Atom or RSS feeds containing any data that you...
2017-01-18
44 reads
From request to delivery in 5 minutes or less! xSQL RSS Reporter for SQL Server enables you to generate standard...
2017-01-18
243 reads
Dear All,
After a short break, we are back with the 3rd interview on #DataChannel. Mr.Hamish Watson, Community Lead from Christchurch,...
2017-01-27 (first published: 2017-01-18)
1,077 reads
I sometimes forget that Microsoft watches out for us by proactively looking at the behaviour of our SQL databases in...
2017-01-18
513 reads
For those not aware there are 2 cool local and national events coming to both Melbourne and Gold Coast… SQL Saturday 582 (Sat 11 Feb 2017). Melbourne. For those looking for...
2017-01-17
12 reads
For those not aware there are 2 cool local and national events coming to both Melbourne and Gold Coast…
SQL Saturday582 (Sat...
2017-01-17
561 reads
This just in from the Reporting Services product team: “Power BI reports in SQL Server Reporting Services: January 2017 Technical...
2017-01-17
690 reads
Last week I presented my session High Performance SSRS at the inaugural GroupBy Conference. It was an incredibly fun experience getting to present a topic I'm excited about as...
2017-01-17
26 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