Spaces in Object Names Revisited
I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and...
2009-10-05
840 reads
I think in general the SQL Server DBA’s of the world prefer that object names not have spaces embedded, and...
2009-10-05
840 reads
Over the past few years we’ve had a number of recruiters and staffing firms visit oPASS as sponsors, and we...
2009-10-04
367 reads
You can read the full text of it in today’s SSC Newsletter, the quick summary is that for many businesses...
2009-10-02
262 reads
It was nice to work through my email and find a bit of positive news instead of more work! I’m...
2009-10-02
402 reads
There are lots of technical people that are forced to be DBAs by necessity. However there is another class of DBAs, the Incidental DBAs. Andy Warren brings a guest editorial that reminds us about this group of people that work with SQL Server.
2009-10-02
204 reads
In this case making money is about counterfeiting. The Art of Making Money: The Story of a Master Counterfeiter ($18)...
2009-10-01
401 reads
I try not to post too many links without some thoughtful commentary, but I ran across this and thought it...
2009-10-01
279 reads
I’ve had the glimmer of this idea since I posted about the idea of bringing my chair to the 2009...
2009-09-30
1,393 reads
Hopefully you saw it in the special mailing that went out yesterday, but the marketing team just released a new...
2009-09-30
1,377 reads
We’re closing in on our October 17th SQLSaturday #21 in Orlando and I thought I’d share a few things about...
2009-09-30
1,409 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