Google IQ Test
Friday (Dec 20, 2013) the Google Doodle was a crossword puzzle. I was curious so I clicked and yes, it...
2013-12-23
718 reads
Friday (Dec 20, 2013) the Google Doodle was a crossword puzzle. I was curious so I clicked and yes, it...
2013-12-23
718 reads
Achieving a certification is less about the actual accomplishment, and how you get there. Read some of Andy Warren's thoughts.
2013-12-23
183 reads
I’m a bit late posting this, but it’s worth a couple minutes to check out the Community Choice awards, might...
2013-12-23
929 reads
Last week I had one of those days when I read something and then heard someone talking about the same...
2013-12-16
914 reads
For those that attended the webcast I did last week for Idera the companion whitepaper is now available for download....
2013-12-11
840 reads
Today I ran through the first tutorial at Code.org. It has 20 very short lessons that use Angry Birds and...
2013-12-11
636 reads
Today at 3 pm EST I’m presenting Surviving The First Week As The New DBA. Some of the topics I’m...
2013-12-05
695 reads
Today we have a guest editorial from Andy Warren. Today Andy talks about his changing role as a DBA and how many tasks he doesn't need to handle anymore.
2013-11-29
231 reads
The Abilene Paradox by Jerry Harvey is not a new book, written in 1988. It’s part of some reading I’m...
2013-11-27
1,339 reads
Today we have a guest editorial from Andy Warren. There are often issues with how we get along with each other at work. Andy asks how you might handle a tough decision over a simple problem.
2013-11-27
190 reads
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Comments posted to this topic are about the item Pay for Performance, which is...
Comments posted to this topic are about the item Switching Schemas I
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
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