Rules of Holes #7: Some Will Look Down on You.
I've been extoling the Rules of Holes, hoping to give you both courage to get out of your Hole, and solace for having allowed yourself to get in a...
2012-11-30
12 reads
Rules of Holes #7: Some Will Look Down on You.
I've been extoling the Rules of Holes, hoping to give you both courage to get out of your Hole, and solace for having allowed yourself to get in a...
2012-11-30
22 reads
Reblog: November 23 to November 29
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2012-11-30
1,490 reads
Power View for Multidimensional Models – Preview Available
Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View can only consume data...
2012-11-30
2,388 reads
Sharing the Love
Just a few blog posts that you ought to go and read.
First up, Tom LaRock maintains a listing of SQL...
2012-11-30
1,692 reads
Rules of Holes #7: Some Will Look Down on You.
I've been extoling the Rules of Holes, hoping to give you both courage to get out of your Hole, and...
2012-11-30
1,537 reads
Tables without a Primary Key
As well as creating the script for yesterday’s post on finding Tables without a Clustered Index I tweaked the script...
2012-12-06 (first published: 2012-11-30)
5,248 reads
SQL Saturday in Washington D.C. December 8, 2012
This is my first time attending a SQL Saturday event and I’m quite excited. If you live in or near...
2012-11-30
1,226 reads
New Book: Knight’s SSIS 2012 24-Hour Trainer
I’m very excited to announce that you can now purchase my latest release book:Knight’s Microsoft SQL Server 2012 Integration Services...
2012-11-30
3,335 reads
Backup History
This is a quick rewrite of the script I just posted a few days ago. The script had a few flaws if trying to run it on a SQL...
2012-11-30
33 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
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