SQLCMD – Database Backup and Restore – Automation – Quickest and Simplest method
In today’s world we rely more on third party tools to do a Backup and Restore of databases. Most of...
2013-08-19
4,456 reads
In today’s world we rely more on third party tools to do a Backup and Restore of databases. Most of...
2013-08-19
4,456 reads
Care about RPO’s and RTO’s? Then you should be backing up your Windows AzureSQL Databases(Formerly SQLAzure).
Windows Azure SQL Database is...
2013-08-19
1,553 reads
You’ve enabled Transparent Data Encryption (TDE) on one of your databases, and the server has failed. How do you get...
2013-08-19
1,095 reads
It’s Monday, it’s time for weekly round-up #45. Technically, this should be #46, but since I went on vacation, I...
2013-08-19
698 reads
My laptop is out for repair. I’m working currently on a Surface Pro instead. It’s spurred me to do something...
2013-08-19
810 reads
This past weekend I’ve been reading The Zen of Listening by Rebecca Shafir, part of my ongoing efforts to be...
2013-08-19
698 reads
CDC changes column-by-column instead of row-by-row, can you improve it???.
2013-08-19
832 reads
Wouldn’t it be nice if SQL Server allowed this functionality? for instance if did the below:-
I get the above error....
2013-08-19
1,071 reads
When running SSIS packages in BIDS it is common to click on the green arrow at the top of BIDS...
2013-08-26 (first published: 2013-08-19)
2,082 reads
Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it...
2013-08-19
1,516 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