SQLPASS Day 2: Keynote Live Blog
Them's some SEXY DBAs...
I’m live blogging the PASS keynote…it’s 8:44 local time.
Here’s the PASS website description of the day 2 keynote...
2010-11-10
521 reads
Them's some SEXY DBAs...
I’m live blogging the PASS keynote…it’s 8:44 local time.
Here’s the PASS website description of the day 2 keynote...
2010-11-10
521 reads
12:42pm local time at the live streamed Women in Technology luncheon…let’s blog. I’ll italicize my comments, to differentiate betwee that...
2010-11-10
1,133 reads
Day 1 Keynote Jumps the Shark with Tina Turner Impersonator
I’m live blogging the PASS keynote…it’s 8:38 local time.
You wouldn’t guess...
2010-11-09
771 reads
Better pull out the excuse-o-meter
I have no excuse, none whatsoever.
In my T-SQL Brush-Up presentation to the North Texas SQL Server...
2010-11-03
858 reads
You there, sitting in your cube and fuming at all the PASS Summit talk: you couldn’t talk your company into...
2010-11-01
896 reads
IN SQL Server 2000, we didn’t have the fancy-schmancy Management Studio…we had Enterprise Manager and Query Analyzer, and we liked em,...
2010-10-27
531 reads
On Saturday I (unexpectedly) presented at Dallas’ first Business Intelligence-focused SQL Saturday at the Microsoft campus in Irving. I wasn’t on...
2010-10-25
1,523 reads
SQL Saturday #56, Dallas BI edition, is tomorrow. Last night before the NTSSUG meeting, we had an unusually high number of...
2010-10-22
805 reads
Last week I wrote Ground Zero Database Design, thinking that was a good enough bare-bones intro (with recommended reading!) that...
2010-10-20
756 reads
This shirt was specifically requested by an online friend who shall remain nameless (his name rhymes with “Duck Hoodie”). Another...
2010-10-20
1,107 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