RTFM365 Week 0
For the next year, I will read from SQL Server Books Online a little every day, and blog about it weekly. ...
2010-12-03
724 reads
For the next year, I will read from SQL Server Books Online a little every day, and blog about it weekly. ...
2010-12-03
724 reads
I’ve got to figure out a good way to present a regular summary of what we do every week. Until...
2010-12-02
655 reads
Physicians have primum non nocere – a Latin phrase that means “First, do no harm”. (Thank you, WikiPedia.) I think for...
2010-12-01
599 reads
For the last two years, I’ve participated in Sean’s InfoWorld Xmas Wish List, where we review a bunch of cool...
2010-11-24
579 reads
Hi-ho all, and a wonderful Un-SQL event it’s been! We had at least twenty-six entries!! First, the recap:
While T-SQL Tuesday...
2010-11-23
805 reads
Here is my contribution to my blog party, Un-SQL Friday 001: Branding. Join in the fun, won’t you?
I have a...
2010-11-19
1,023 reads
Denali. No, not that one...
How many of you have heard that the Community Technology Preview (CTP1) for the next version...
2010-11-18
744 reads
In the spirit of T-SQL Tuesday, I hereby declare this Friday Un-SQL Friday. While T-SQL Tuesday is “…the SQL Server...
2010-11-17
614 reads
PASS Summit 2010 is over, and we are suffering from the lack of chatter and SQL celebrity sightings. Bloggers are...
2010-11-15
592 reads
I’m live blogging the PASS keynote…it’s 8:44 local time.
Me: Tuesday is #SQLSat shirt day, Wednesday is #sqlkilt day, Thursday is...
2010-11-11
704 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