Comments on the SQL in the City Tour
There’s still anevent in Seattle in a few weeks. As I’ve been traveling around the country, literally around through New...
2012-10-09
1,372 reads
T-SQL Tuesday #35 – Soylent Green
This month’s host is Nick Haslam (b | t) and he bases his question on the movie Soylent Green, which I...
2012-10-09
971 reads
Retrieving Driver Information
Recently, I had a need to take a look at all of the drivers for a specific set hardware on...
2012-10-09
453 reads
Interview with a #SQLPASS Candidate – @NTSSUG’s Sri Sridharan!
Last week, Sri Sridharan (Twitter, blog) and I sat down on the Internet to talk about his run for the...
2012-10-09
709 reads
MDS Error: “Cannot insert the value NULL into column ‘Code’”
In Microsoft Data Services (MDS), when running a stored procedure to process a staging table (stg.udp_name_Leaf), I received this error:
“Cannot...
2012-10-09
1,261 reads
My PASS Board Vote
I’m not a politically minded person and this is not the type of post I would normally write. However, I’m...
2012-10-09
778 reads
SQLSaturday #171 Pittsburgh recap
This past weekend I made the drive from Cleveland to Pittsburgh to attend SQLSaturday #171. They picked the perfect time...
2012-10-09
579 reads
Reminder to Register for the Monday Night Networking Party
We just crossed the 100 mark for registrants for our Monday Night Networking Party and still room for more. If...
2012-10-12 (first published: 2012-10-09)
1,821 reads
Microsoft Security Bulletin MS12-070 for SSRS
Today is black Tuesday for October 2012. One security bulletin is specifically for a component of the SQL Server stack:...
2012-10-15 (first published: 2012-10-09)
4,305 reads
A Journey To SQL Authority
I am delighted to welcome to the blog someone who is without a doubt one of the biggest names in...
2012-10-09
1,137 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