SqlPackage Deploy Performance - IgnoreXX are not your friend!
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the...
2017-03-02
49 reads
Following on from yesterdays blog I was wondering about the comparison of objects that were the same and how the...
2017-03-02
49 reads
When ‘Enforce Password Policy’ for SQL Server logins is turned off, you can make your password anything you want! Hooray!...
2017-03-02
499 reads
In my introduction to the topic of using SSIS in the cloud, I noted that SSIS is not currently available...
2017-03-02
434 reads
Log shipping provides a means to maintain a secondary server on an automated basisusing a chain of transaction log backups. This chapter explains the basic confi guration oflog shipping...
2017-03-02
37 reads
Log shipping provides a means to maintain a secondary server on an automated basis
using a chain of transaction log backups....
2017-03-02
21,723 reads
A fundamental component of SQL Server is the security layer. This article covers three common security misconfigurations in SQL Server.
Related Posts:
When Too Much is Not a Good Thing December...
2017-03-02
107 reads
EZ PZ Permission Squeezee
Given the critical level of importance related to permissions, one may think it is a concept that...
2017-03-02
1,463 reads
OK, for no particular reason at all or maybe because I had too much food at lunch or just because...
2017-03-02
401 reads
J.C. Penney is one of the oldest and most storied retailers still in existence in the United States. For years,...
2017-03-02
387 reads
A nice little error log feature that I noticed in SQL Server 2016 regarding tempdb. Tempdb, a system database in...
2017-03-02
421 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