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
Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server?
Are you wondering when...
2013-01-30 (first published: 2013-01-24)
4,263 reads
If You Need To Fix Database Filename Extensions
In a recent post I showed how the file extension for a database doesn’t matter. It can be confusing, however,...
2013-01-24
1,568 reads
SQLSaturday 194 (Exeter)
It’s an exciting time for SQL Server Professionals in the South West of the UK, we’re now just a few...
2013-01-24
741 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