Fix SQL Server Commvault Backup Failures After an Upgrade
One of my friend sent an email that backups of a SQL Server 2016 instance are failing suddenly when the...
2017-02-10
1,289 reads
One of my friend sent an email that backups of a SQL Server 2016 instance are failing suddenly when the...
2017-02-10
1,289 reads
Wow – I didn’t blog at all in 2016! While I’m certain that falls squarely on me, perhaps a small part...
2017-02-10
1,615 reads
MANAGING ‘NOISY NEIGHBORS’ IN SQL SERVER If you’ve been managing databases for any length of time, you’ve probably had to contend with the “noisy neighbors” scenario. In this scenario,...
2017-02-10
37 reads
I recently stumbled on a YouTube channel from one of my favorite SQLPeople - she is sharp (and an MCM) and...
2017-02-10
616 reads
Fun week, performed some RAM upgrades for my production SQL boxes which for one server, somehow fried its motherboard, hard...
2017-02-10
390 reads
This is a cool productivity trip, and one that I ran into by accident. I had heard that I could...
2017-02-09
1,962 reads
Throughout many years of working with BI solutions and data warehouse solutions, we have strived to put all the data...
2017-02-09
670 reads
This is part 2 of the Getting Started with Power BI series. Power BI is a powerful reporting and dashboarding...
2017-02-09
189 reads
I am honored to have been recommended by a colleague and selected as a speaker for the Triad Developer’s Conference...
2017-02-09
366 reads
Just a quick blog post so that other people don’t waste 15 minutes of their life looking for a missing...
2017-02-17 (first published: 2017-02-09)
2,790 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