Book Review: The Cleaner
I read The Deceived a few weeks back and enjoyed it, even though it was the 2nd book in the...
2009-11-19
507 reads
I read The Deceived a few weeks back and enjoyed it, even though it was the 2nd book in the...
2009-11-19
507 reads
I’ve had this on my list of things to talk about someday, a recent post on almost the same subject...
2009-11-18
616 reads
In a recent blog post Brent Ozar questioned why PASS decided to relaunch the SQL Server Standard given the failure...
2009-11-17
759 reads
Last Monday was my first day back from the PASS Summit, planned for (and was) a slow day, just starting...
2009-11-16
503 reads
New friend David Easley shared two sources for hot sauce that I wasn’t familiar with:
http://www.datilsensation.com/products.shtmlhttp://www.pepperpalace.com/I like some spice here and...
2009-11-15
536 reads
I grew up watching baseball on TV and playing it too, and for reasons I don’t recall my Dad’s favorite...
2009-11-12
555 reads
A few weeks ago I was looking for a few branded items, happened to run across drink coasters at 4imprint....
2009-11-11
593 reads
I’m sure you know what I mean when I say that I feel like my ability to task switch and...
2009-11-11
494 reads
A short post today, ran across http://www.lifeoptimizer.org/2007/03/08/66-best-quotes-on-time-management/ when I was looking for ideas for my Moo cards. Quotes are fun...
2009-11-10
498 reads
I was up early again on Friday morning to have breakfast with Patrick Leblanc (SQLLunch man), and then off to...
2009-11-09
635 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