CDC changes column-by-column instead of row-by-row, can you improve it???
I’m writing a table value function that returns a cdc recordset that, instead of returning changed data row-by-row, I need...
2013-08-19
678 reads
I’m writing a table value function that returns a cdc recordset that, instead of returning changed data row-by-row, I need...
2013-08-19
678 reads
What is Page Life Expectancy (PLE), what makes it drop, and how can I manage memory better? Abusing disks slows...
2013-08-20 (first published: 2013-08-19)
4,879 reads
Dear reader, I would like to share with you some of the capabilities that the Power Query for Excel brings...
2013-08-22 (first published: 2013-08-19)
4,978 reads
This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data and Hadoop environment. To discover more about Python please...
2013-08-18
74 reads
This reblog post should have come out last Friday, but I was on vacation and I didn’t want any new...
2013-08-18
464 reads
This blog is not for pure Python lover. In this article I will describe usefulness of Python in Big Data...
2013-08-18
588 reads
Today I had the pleasure of speaking at the SQL Saturday #235 in New York City. Talk about an absolutely...
2013-08-17
709 reads
http://bit.ly/16UyEPHHello Dear Reader. Almost two weeks ago I delivered a presentation for the 24 Hours of PASS on SQL Server...
2013-08-16
952 reads
Has anyone ever though of pushing a SQL Server database backup out remotely? (SQL Native andor RedGate Backups) My idea...
2013-08-21 (first published: 2013-08-16)
4,866 reads
I am writing this blog post en route to New York City for SQL Saturday #235. This begins a fairly...
2013-08-16
606 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