Share custom solutions in the MinionWare Community Zone
Since we released Minion Reindex over a year and a half ago, we’ve had a ton of wonderful feedback, praise, questions, and...
2016-06-07
637 reads
Since we released Minion Reindex over a year and a half ago, we’ve had a ton of wonderful feedback, praise, questions, and...
2016-06-07
637 reads
Come meet Codex! We’ve had many of you asking to be part of the Minion CheckDB beta and now is...
2016-05-18
681 reads
Here’s your friendly neighborhood reminder to get free learnin’ at SQL Saturday Houston this weekend, where we’ll have the MinionWare booth, and sessions...
2016-05-12
523 reads
Just a fun note, because it was a moment of pure puzzlement for me. I’m writing a new SP for Minion Backup...
2016-04-25 (first published: 2016-04-18)
2,969 reads
Bonus summary: xp_cmdshell is limited to admins, unless you specifically grant permissions to users. And if you’re an admin, you have...
2016-04-14 (first published: 2016-04-09)
1,774 reads
As often as I have to pull a job’s name based on its job_id in the MSDB system tables, I’m truly...
2016-04-08 (first published: 2016-03-28)
1,493 reads
Let it be known that the word “backup” is a noun (it refers to a thing), and “back up” is a verb (it...
2016-04-07
528 reads
Sean and I have put together our bazillion (read: like 30 combined) years of SQL Server DBA-ing into one big,...
2016-03-16
489 reads
Today let’s talk about shrinking log files, and Minion Backup – still totally & forever free – and how they go together. First...
2016-02-25 (first published: 2016-02-22)
2,636 reads
SQL Server 2016 offers Row Level Security, which sounds awfully cool. It’s apparently been available in Azure for a while,...
2016-02-25
1,124 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