SQL Server 2008 Service Pack 3 Cumulative Update 9
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update 9, which is build 10.00.5829. As you might expect...
2013-01-25
1,583 reads
Type 2 SCD with SQL Merge
I was going through some notes I had from previous projects and came across a sample script for created a...
2013-01-25
10,949 reads
Reblog: January 18 to January 24
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-25
1,062 reads
New Years Aspirations – Kevin Kline – Presenting
I’ve been very privileged to be able to work alongside Kevin on a few projects during our time together at...
2013-01-25
893 reads
Replication Latency
I've used Replication a lot over the years and contrary to the opinions of most DBA’s I know, I think it...
2013-01-25
2,123 reads
SQL Server Non Clustered Index Tutorial for Beginners
In the past I have come across comments like SQL Server is slow (small tables) or interviews where someone had...
2013-01-25
2,454 reads
Backup SQL database directly to Azure Storage
There is a new CU update for SQL 2012 SP1 and I noticed a very interesting new feature described in...
2013-01-25
1,535 reads
Day 20 of 31 Days of Disaster Recovery: The Case of the Backups That Wouldn’t Restore
I have decided to spend day 20 of my 31 Days of Disaster Recovery series by relating a true tale...
2013-01-25
1,145 reads
I'm an Administrator Why Can't I Copy Files
Hello Dear Reader! I've been working on setting up a virtual environment for quite some time. When last I wrote...
2013-01-31 (first published: 2013-01-24)
2,808 reads
Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server? Are you wondering when the setting for max degree of parallelism was...
2013-01-24
19 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