Before Asking for Help...
I have a standard rule that I use before going and bugging a co-worker or posting via social media/message forum about...
2013-08-29
1,893 reads
I have a standard rule that I use before going and bugging a co-worker or posting via social media/message forum about...
2013-08-29
1,893 reads
I have been absent from this blog for the last few months. For those who have noticed, I’d like to...
2013-08-29
879 reads
I could tell you a story about Green Day's cover of John Lennon's classic "Working Class Hero" that you wouldn't...
2013-08-29
820 reads
It seems fitting with the anniversary of Martin Luther King’s “I have a dream” speech that I would write about...
2013-08-28
1,056 reads
Thanks everyone for attending my free webinar on Introduction to Power Query on August, 27, 2013. If you were not...
2013-08-28
1,115 reads
As I mentioned in my original post, Exploring Excel 2013 as Microsoft’s BI Client, I will be posting tips regularly...
2013-09-04 (first published: 2013-08-28)
2,158 reads
Have you always wanted to dig into performance tuning but wasn’t sure where to start? If so, check out this Introduction...
2013-09-04 (first published: 2013-08-28)
2,633 reads
I am excited to be able to tell you about an all day seminar that I’ll be putting on prior...
2013-08-28
658 reads
I like practice tests. Once I feel like I’m getting ready to take a certification exam I start taking an...
2013-08-28
1,037 reads
The Setup:
Standard best practise is to have auto create and auto update statistics set for SQL Server databases. But there...
2013-09-03 (first published: 2013-08-28)
3,543 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Equity Tower, Ground Floor, Unit D & Lantai 8, Unit E, Jl. Jenderal Sudirman...
Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec. Cilandak, Kota...
Comments posted to this topic are about the item Switching Schema II
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