Learn T-SQL in 5 Minutes
I will be giving a five minute Lightning Talk at SQLRally in May that aims to do the impossible: Teach...
2011-04-29
2,210 reads
I will be giving a five minute Lightning Talk at SQLRally in May that aims to do the impossible: Teach...
2011-04-29
2,210 reads
I’m reading Tim Ferriss’ “The Four Hour Work Week” (FHWW) right now, and it’s got me thinking about (among other...
2011-04-28
1,479 reads
It’s a busy week for me, and a slow one technically. But I know that you, Constant Reader, thirst for...
2011-04-20
531 reads
The Professional Association for SQL Server (PASS) Women in Technology group first caught my attention at the PASS Summit in 2009...
2011-04-12
1,008 reads
I have made something for your pleasure and entertainment, and placed it on the MidnightDBA YouTube Channel. Please to enjoy...
2011-04-08
520 reads
Dear Readers,
Today’s blog shall be entirely stream-of-consciousness, which is to say, I don’t know exactly what I’m going to talk...
2011-04-07
821 reads
Meme Monday story:
They’d never heard of indexes. Man, I was SUCH a rockstar!
-Jen McCown, MidnightDBA.com/Jen
2011-04-04
600 reads
In the speaker rooms of SQL events everywhere, there is wondrous blog material to be had, free for the picking...
2011-04-04
1,190 reads
SQL Saturday 63 Dallas. Will. Be. Epic.
Here are my proofs:
The Schedule. Note the gelato breaks. It is impossible to get...
2011-04-01
514 reads
I had an interview earlier this week. An interview for a SQL developer position. It went fine. But. Question number X...
2011-03-30
4,648 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