Call for Mentors for The Mentoring Experiment
We’re about to start our second experiment over at The Mentoring Experiment and we need mentors. Last time we picked...
2012-05-04 (first published: 2012-04-24)
1,855 reads
Change Package Properties Using Parameters–SSIS 2012
In DTS, changing package properties was close to impossible (the less we talk about DTS, the better). Package configurations introduced...
2012-04-24
14,302 reads
SQL Server 2005 backups in a hung state because of full text search process
I came across an issue today where a backup process was in a blocked state with a wait type of...
2012-04-24
629 reads
UF Dissolves Computer Science Program, Increases Funding for “Future Jobs”
In a bold and decisive move earlier today, the University of Florida has decided to dissolve their computer science education...
2012-04-26 (first published: 2012-04-24)
3,819 reads
OPASS April Meeting Recap
Last Thursday I had the pleasure of speaking in Orlando, FL at the OPASS monthly meeting. I spoke on Extending...
2012-04-24
1,145 reads
Quick Roundup of Intel Ivy Bridge Reviews
The overall opinion seems to be that the 22nm Ivy Bridge represents a relatively small boost to CPU performance (typically...
2012-04-23
1,055 reads
2012-04-23
1,244 reads
Windows 2008 Server : Moving Cluster Quorum Disk to New SAN
In my earlier post, I have explained how to move the MSDTC disk to new SAN. In this post we...
2012-04-23
9,493 reads
Pragmatic Works Software for MVPs
This is just a quick post to remind folks who are current Microsoft MVPs that Pragmatic Works offers NFR licenses...
2012-04-23
1,100 reads
The Importance of a SQL Server Inventory
Pop quiz!
It’s time to true-up with Microsoft, what are your current license counts?Operations needs to schedule maintenance on ServerY, what...
2012-04-23
2,738 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