SQL Server Consulting: Weekly Round-up
The first full week in 2013 has been a a busy week for me with lots of SQL Server consulting...
2013-01-12
1,008 reads
The first full week in 2013 has been a a busy week for me with lots of SQL Server consulting...
2013-01-12
1,008 reads
31 Days of Disaster Recovery
Welcome back to my series 31 Days of Disaster Recovery. Today is day 11, and...
2013-01-12
4,049 reads
As you may be aware, I have been running a lunch time user group ‘SQLLunch UK’ having stolen drawn inspiration...
2013-01-11
675 reads
Do you know anyone that lives in or around the great white north that is Fargo, North Dakota? If so,...
2013-01-11
687 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-11
5,275 reads
Since the last guide was quite popular (over 4k distinct views for SQL Server 2008 R2), I've uploaded to SkyDrive...
2013-01-11
19,295 reads
Today, I am willing to do demo that under which user my SQL Agent Job run, SQL Agent Service Account...
2013-01-11
4,228 reads
#SQLSaturday194 is coming to Exeter on the 8th – 9th March.
What is SQL Saturday? The brain child of Steve Jones,...
2013-01-11
765 reads
Jorge Segarra (blog | twitter) was giving a presentation and he remarked on how the SQL Server Management Studio shortcuts have...
2013-01-11
7,807 reads
31 Days of Disaster Recovery
It’s day 10 of my 31 Days of Disaster Recovery series, and I want to...
2013-01-11
1,365 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
By DesertDBA
I did not expect 27 responses to my T-SQL Tuesday #204 invitation, but it...
Should you adopt an off-the-shelf AI tool, partner with a specialist, build in-house, or...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
Comments posted to this topic are about the item Switching Schema II
Comments posted to this topic are about the item A Practical Approach to Automating...
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 two rows back for the objects, named dbo.beer and etl.beer. Both the tables have identical schemas and are not partitioned. There are 25 rows in dbo.beer and 0 rows in etl.beer. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers