Presenting at SQLSaturday #48 in Columbia, SC This Weekend
I’m leaving Orlando early Friday morning to drive up to Columbia for SQLSaturday #48 . By the time I changed planes...
2010-10-01
313 reads
I’m leaving Orlando early Friday morning to drive up to Columbia for SQLSaturday #48 . By the time I changed planes...
2010-10-01
313 reads
Sometimes spending some time with your spouse watching TV is right up there with comfort food, the challenge is often...
2010-09-30
1,436 reads
Years ago I was part of a heated discussion about the ability/inclination of a team I was on to build...
2010-09-29
1,543 reads
Lots of events in Florida, easy to lose track! The Tallahassee Code Camp is October 23, 2010, details at http://www.tallycodecamp.org/...
2010-09-29
1,688 reads
I talked about the basics of Influence in Part 1 and Part 2, today I’m trying something harder, showing you...
2010-09-28
720 reads
We’re less than 30 days out from SQLSaturday #49 and we’re working hard on the logistics. Speaker gifts ordered, lanyards...
2010-09-27
640 reads
One of the things we’re trying to do at SQLRally (May 2011 in Orlando!) is support and grow the social...
2010-09-27
576 reads
today we have a guest editorial from Andy Warren that talks about how attitude can influence the impression you make can have a huge impact on how your service is viewed.
2010-09-24
153 reads
I’ve hit that point where it feels like I need to work longer and harder to keep up, which is...
2010-09-21
591 reads
Last Friday saw the end of the 2010 PASS election and it was very nice to find out I had...
2010-09-20
637 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