SQL Saturday Iowa City Precon – The Complete Primer to SQL Server Infrastructure
I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Iowa...
2016-05-05
395 reads
I’m pleased to announce that I’m launching my next round of all-day precon training session at the upcoming SQL Saturday in Iowa...
2016-05-05
395 reads
If you are looking for affordable, high-quality training on SQL Server Integration Services, you may be interested in one of...
2016-05-05
582 reads
After a few days in Copenhagen for SQL Nexus, I traveled to London late last night, and am now making...
2016-05-05
463 reads
PuttingYour Head In the Cloud An Introduction to Cloud Computing and Azure SQLDatabases by David Postlethwaite has been revised in...
2016-05-05
622 reads
Hi friends, in my previous post we have learnt how to implement Row Level Security feature in our database. You...
2016-05-13 (first published: 2016-05-05)
1,495 reads
Three years ago, I left the ranks of full-time employment to become an independent consultant. At the same time, I...
2016-05-04
464 reads
I was delivering a SQL Server upgrade class last week in Toronto Canada. I got asked a slightly off topic...
2016-05-04
3,024 reads
In Azure, there previously has been only one kind of storage account, which is now called a “General Purpose” storage...
2016-05-04
1,100 reads
It always amazes me how often these three commands get confused. Heck it amazes me how long I confused them....
2016-05-04
1,152 reads
I stumbled across a small MDX performance tuning trick when using SSRS reports (or any other client tool where you...
2016-05-04
595 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