Devops without management buy in?
I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database...
2017-02-10
72 reads
I was talking to someone at a meetup recently who was really keen on doing continuous deployment for their database...
2017-02-10
72 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
38 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,963 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
190 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
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