How to Speak to a Tech
Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too...
2011-06-14
653 reads
Hi all! I’m on vacation this week, but I’ve cleverly scheduled this blog post so you won’t miss me too...
2011-06-14
653 reads
We had a cozy (read: small) UnSQL Friday this time around, and I’m good with that. Every entry we got...
2011-06-09
853 reads
This month’s Meme Monday is “dumb SQL questions”. Here’s the one that gets under my skin the most these days:
Let me...
2011-06-06
663 reads
This is my contribution to UnSQL Friday #004: Speaker Lessons Learned.
I got my SQLRally session evaluation back last week. I’d...
2011-06-06
594 reads
I began writing a story about, shall we say, a less than positive speaking experience…and then I realized: This is...
2011-06-02
1,104 reads
On May 12, during the first-ever SQLRally , we held the first-ever SQLRally Women in Technology luncheon! I moderated, and our...
2011-05-26
1,028 reads
If you’re already a MidnightDBA Groupie, then you’ve probably already heard about my fabulous inspiration: a new SQL community podcast! Now...
2011-05-23
1,637 reads
I am, as they say, one busy little bee.
I just got back from SQLRally last week (here are my SQLRally...
2011-05-20
567 reads
I have a session I like to give called “Forgotton T-SQL”, or sometimes “T-SQL Brush-Up”. The idea is that there’s...
2011-05-17
800 reads
Look at the cute bunny. Now go vote for me.
I can see October from here, and it’s coming at about...
2011-05-10
544 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