Countdown to PASS Summit 2012 – 6 to Go – Magenic Brings 9
Getting closer, 6 days to Summit 2012! Today, I just have to give kudos out to Magenic, my current employer....
2012-10-31
1,238 reads
SQL PASS Summit just one week away!
Happy Halloween everyone!
I’m stoked that the SQL PASS Summit is just one week from now! You are already registered, have...
2012-10-31
1,254 reads
Microsoft Surface Update
Let’s talk some more about the basic keyboard. I’m really surprised at how well it works. But, it’s absolutely going...
2012-10-31
1,460 reads
Learn Good / Do Good
Obviously the title of this post is an exercise in bad grammar, but it’s a little catchy. Well, maybe not,...
2012-10-31
1,504 reads
Don’t believe everything you read: Truncate table is not logged
Actually I’m not sure if anyone still believes this anymore. If you read the BOL description carefully it states that...
2012-11-02 (first published: 2012-10-31)
4,452 reads
Developing Microsoft SQL Server 2012 Databases (70-464) – My Thoughts
I finally pulled my finger out and took the last exam of the MCSE SQL Server 2012 – Data Platform certification...
2012-10-30
6,902 reads
PASS 2012 Countdown – 1 Week To Go
Oh, dear! One more week until this year’s PASS Summit. If you haven’t registered yet, you’re really cutting it close. ...
2012-10-30
1,457 reads
Countdown to PASS Summit 2012 – 7 to Go – My First Summit Presentation
Seven days, one full week, until opening night at Summit 2012. Getting excited yet? In my first post of the...
2012-10-30
1,256 reads
SQL Server 2012: New Business Intelligence features
SQL Server 2012 has many new Business Intelligence (BI) features and enhancements. Here are my top 12, in order of...
2012-10-30
8,668 reads
Lost in Translation – Deprecated System Tables – sysindexkeys
This post is part of a blog series which focuses on translating compatibility views in SQL Server to their respective...
2012-10-30
1,528 reads
Blogs
T-SQLTuesday 204: Are blogs still relevant?
This month’s blogging party is hosted by Jeff Ianucci – his challenge is to...
Are Blogs Still Relevant? I Think They Still Are.
As for me, I'll keep writing whenever time permits. I don't expect every post...
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
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 one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers