How To Win Career Gold
The start of a new working year is often a time for self reflection. This is a great thing, it’s...
2013-01-22
1,101 reads
The start of a new working year is often a time for self reflection. This is a great thing, it’s...
2013-01-22
1,101 reads
Most of the scripts I’ve used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
847 reads
Most of the scripts I've used to populate date dimension uses a cursor. Since data is loaded only once to...
2013-01-22
2,506 reads
This post is first of yet to come long series on basic concepts of SQL Server. I’ll begin with basic...
2013-01-22
816 reads
During your career as a DBA, you'll run across articles by SQL experts or other DBAs that just give you...
2013-01-22
1,373 reads
The features and capabilities of Power View have definitely improved since its release. One of my favorite features is the...
2013-01-21
3,745 reads
I would hope that most of us have used a thesaurus at some point in our careers. These allow us...
2013-01-25 (first published: 2013-01-21)
5,275 reads
Hello Dear Reader! Since I’ve joined Pragmatic Works I’ve learned a lot, seen a lot, and assisted in interviewing a...
2013-01-23 (first published: 2013-01-21)
5,101 reads
Sometime before, I was giving training on basics of SQL Server. One of attendee is having doubt & want to confirm...
2013-01-21
765 reads
OPASS meetings are held at Logans Roadhouse in Sanford now, I think the fourth location over the past couple years,...
2013-01-21
702 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