Fish and Chips, Robin Hood, SSIS, and Me
I’m going to Nottingham, England, fabled home of Robin Hood, where I’m going to eat fish and chips and talk...
2013-01-30
1,540 reads
Small changes, big effects
We got a call last week about an application that was running slowly. The server was showing about 80% CPU...
2013-01-30
1,272 reads
SQL and Skiing – SQL Saturday #183
This weekend of SQL Saturday #183 in Albuquerque, NM. It’s the first SQL Saturday in that state, and it’s a...
2013-01-30
1,502 reads
Performance Impact from Page Splits
Recently I was brought in to help troubleshoot performance issues on a database server. Going through my typical check list...
2013-01-30
1,972 reads
Azure SQL Database Execution Plan Differences
I’ve been exploring execution plans in Azure SQL Databases a lot lately. I’m getting a presentation together for some upcoming...
2013-01-30
1,915 reads
SSIS 6 Million Rows in 30 Seconds using standard laptop
First of all I would like to thank Koen Verbeeck and Joost van Rossum for great suggestions that helped to...
2013-01-30
1,787 reads
SQL Server – Attach Database with MDF file only
Earlier on my blog I posted about how you can attach a database using T-SQL when no log file is...
2013-01-30
2,765 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 5: The Neural Network Algorithm
by Steve Bolton
Anyone who has been following this series of self-tutorials has probably grown accustomed to me adding some...
2013-01-30
2,996 reads
Are You Signed Up for 24 Hours of PASS–Business Analytics?
If you have not signed up for the 24 Hours of PASS-Business Analytics you should be. This is a great...
2013-01-29
1,376 reads
Transactional Replication Toolbox Scripts: Show Articles And Columns For All Publications
During the last few years I've worked extensively with transactional replication and have written a handful of scripts that have...
2013-02-05 (first published: 2013-01-29)
2,778 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