Announcing Minion CheckDB release date!
Minion CheckDB is the third piece of our free backup and maintenance tools, rounding out the list with Minion Backup...
2016-11-28
1,068 reads
Minion CheckDB is the third piece of our free backup and maintenance tools, rounding out the list with Minion Backup...
2016-11-28
1,068 reads
Harassment is a problem at some of the conferences we go to. What can we, as attendees and speakers and...
2016-10-11
424 reads
People new to SQL often have trouble with the difference between WHERE, GROUP BY, and HAVING…three separate clauses in the...
2016-10-07
630 reads
The last week of October, we’ll be at the PASS Summit in Seattle, WA. As some of you already know – and as I...
2016-09-06
519 reads
On October 7 we will be presenting a full day of maintenance and backup learnin’! Register here: https://www.eventbrite.com/e/sql-saturday-564-the-lifecycle-approach-maintenance-problems-solutions-tickets-26867268724 And while you’re at...
2016-09-05
476 reads
I’ve put up a Twitter poll to find some answers to the question: Why do speakers teach at events? Especially at...
2016-08-29
855 reads
Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events...
2016-08-26
507 reads
I’m working on a new session* that I’ve named “T-SQL’s Hidden Support Feature”. It’s about comments. I’ll get to the...
2016-08-12 (first published: 2016-08-08)
2,007 reads
We’ve done this before, but we can go one better this time. Let’s take this step by step. NULL means...
2016-08-11
1,052 reads
UPDATE: Last week, PASS announced an update to the 600 mile radius announcement: “…we will be piloting the 600-mile driving radius...
2016-08-10 (first published: 2016-08-01)
1,202 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