Would You Listen To The Steve & Andy Radio Show?
My friend Steve Jones and I have talked every week for a long time, close to ten years now. On...
2012-08-18
978 reads
My friend Steve Jones and I have talked every week for a long time, close to ten years now. On...
2012-08-18
978 reads
Today, my first article (ie. Different ways to audit SQL Server security) published on SearchSQLServer.com. In this article, I discussed...
2012-08-17
1,103 reads
I’ve been giving a Prepare for When Disaster Strikes talk at SQL in the City this year, and it’s designed...
2012-08-17
1,526 reads
Well, it’s been awhile since I’ve written anything. I have lots of excuses for not writing, but none of them are rally valid. There are 2 real reasons for...
2012-08-17
33 reads
I was watching a training video last night and the instructor made the statement we hear all the time:
"Test this...
2012-08-23 (first published: 2012-08-17)
4,628 reads
Well, it’s been awhile since I’ve written anything. I have lots of excuses for not writing, but none of them...
2012-08-17
800 reads
RAID (Redundant Array Independent Disk) As disk/storage plays a very important role in any application, everything is saved on disk...
2012-08-17
917 reads
Got this question in an email. I'll paraphrase.
William Hoping you can advise me on best way to handle this. My client doesn’t...
2012-08-16
697 reads
If you’re like me, you take advantage of the default backup paths in SQL Server. It makes my code cleaner,...
2012-08-16
1,967 reads
Windows Azure SQL Database also known as SQL Server Data Services or simply SQL Azure is a Microsoft’s cloud services...
2012-08-16
1,958 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