Applied SQL: sys.objects
I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.
Prerequisites: basic...
2011-08-17
1,387 reads
I introduce this whole concept in Applied SQL: You Have Homework. Find all assignments on the Applied SQL page.
Prerequisites: basic...
2011-08-17
1,387 reads
I found myself saying this week – for the N-zillionth time – that while studying is vital, it isn’t everything. What do...
2011-08-17
590 reads
This has to be the best error I’ve ever seen:
Msg 195, Level 15, State 10, Line 2
‘SUM’ is not a...
2011-08-11
846 reads
It’s time for the Un-SQL Friday #005 roundup!
From managers…
First up, The Lone DBA admits that he wasn’t always (ahem) one of us…he’s got...
2011-07-29
1,782 reads
Depending on whether you’re (A) me, or (B) you, the next few weeks are either (A) an insanely busy but enjoyable...
2011-07-25
573 reads
Yesterday a friend told me a tale of an interview he conducted with a, shall we say, less than desirable...
2011-07-19
707 reads
Content Rating: Beginner, Tips
It’s entirely possible that you’re fiddling with your search arguments too much, and missing out on the...
2011-07-18
819 reads
I am easily distracted. Lucky for all of us, I tend to be distracted by cool tidbits in SQL Server...
2011-07-14
1,004 reads
It’s Meme Monday time! Our topic is SQL Horoscopes, or more catchily, SQLStrology.
We’re going to have to figure out what astrological...
2011-07-11
957 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-20
1,583 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