PASS SQLRally Call For Speakers Update
Well, we have 3 days left in the PASS SQLRally Call for speakers and we are doing well. We have over 70 completed submissions, there may be more in a...
2010-12-13
10 reads
Well, we have 3 days left in the PASS SQLRally Call for speakers and we are doing well. We have over 70 completed submissions, there may be more in a...
2010-12-13
10 reads
There is only one week left to submit your abstract for the PASS SQLRally. This is a great opportunity for...
2010-12-08
369 reads
Ever feel worn out and/or burned out? Don’t worry you aren’t alone. As a matter of fact most people have...
2010-12-02
591 reads
Since it is the week of Thanksgiving in the United States, Jason Strate (@strateSql) has requested that bloggers post what...
2010-11-24
593 reads
Call for Speakers
With the close of the PASS Summit today, the call for speakers for PASS SQLRally has opened! so...
2010-11-11
334 reads
As most of you know, I am not attending the PASS Summit this year. I had all my plans made,...
2010-11-09
634 reads
Several bloggers have posted what their plans are for the PASS Summit and I’m following suit for 2 reasons:
So people...
2010-11-03
675 reads
This month T-SQL Tuesday is hosted by Paul Randal (@PaulRandal) and he asks the question, “Why are DBA Skills Necessary?”.
The...
2010-11-02
523 reads
If you read this blog you probably already know about the PASS SQLRally and that we are doing things a little...
2010-10-28
384 reads
SQLSaturday #49 – Orlando was this past weekend (October 16th, 2010). As one of the event organizers the entire week was...
2010-10-21
579 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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