The Field Museum – SQL in the City 2012 – Chicago
Chicago is a neat down. My first PASS Summit was in Chicago, back in 1999. My wife joined me with...
2012-09-04 (first published: 2012-08-29)
2,422 reads
Misc Links for Aug 29,2012
Sword fighting. A friend sent me this, debunks the movie view we have of sword fighting. I can’t say I...
2012-08-29
1,638 reads
SQL Audit 302 – Deploying the Audit Solution with Powershell
This is it, ladies and gentlemen. One last post and I promise I won’t mention the word audit for at...
2012-08-29
2,655 reads
Free Second Shot offer for Microsoft Certification Exams
Nothing for me to really say except if you mess up, you get a free second chance Click HERE to see...
2012-08-29
1,160 reads
September 2012 Speaking Events
September is another busy month of speaking events for me and I thought I’d share them with you so maybe...
2012-08-29
1,735 reads
SQL in the City – FREE Training
Is SQL in the City coming to a town near you? The events are being held in New York, Austin,...
2012-08-29
1,418 reads
Upcoming Speaking Events
I will be the inaugural speaker for the Northern Colorado Database Professionals on September 17, in Loveland, CO. I will...
2012-08-28
2,042 reads
Suppressing namespace attributes in nested select statements when using FOR XML workaround
I was helping out on the forums the other day with a user who had stumbled across the quirk of...
2012-08-28
6,915 reads
Lookup transformation in SSIS: Performance Improvements
There are 2 suggestions I hear about when performance tuning the Lookup transformation on a large dimension table when getting...
2012-08-28
9,157 reads
Parallel Data Warehouse (PDW) How-To: Check Database Size with DBCC_pdw_showspaceused
There is a way to view the size of a particular PDW database using the DBCC_pdw_showspaceused command via the NEXUS...
2012-08-28
3,408 reads
Blogs
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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...
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