Continual Deployment of Visual Studio SqlProj
Unveil the inner workings of the esoteric build system...
As a data professional, I've never worked extensively with msbuild or other...
2016-05-16
3,257 reads
Unveil the inner workings of the esoteric build system...
As a data professional, I've never worked extensively with msbuild or other...
2016-05-16
3,257 reads
It started with a tweet from Dusty
The second session I presented at the fantastic PowerShell Conference Europe was about using the...
2016-05-16
825 reads
Recently while working on a scenario I found that in case of transaction if you are doing insertion operation on...
2016-05-16
566 reads
In SQL Server, the concurrent creation of temporary tables from many sessions can lead to tempdb metadata contention. Tempdb metadata contention does not affect the concurrent creation of table...
2016-05-15
37 reads
With SQL Server AlwaysOn Availability Groups, when you configure a secondary in synchronous-commit mode for read-only access, there can be data access latency. If you make changes to your...
2016-05-15
27 reads
When SQL Server has a choice of plans, it will compare the cost among a set of execution plans and will choose the cheapest one. In some cases, even...
2016-05-15
55 reads
SQL Server configuration parameter “optimized for ad hoc workloads” can be very useful when you execute lots of single use ad hoc statements or dynamic SQL statements by reducing...
2016-05-15
42 reads
When it comes to lock waits, one of the important information we need to know is which statement waited for locks and how long. This is possible with extended...
2016-05-15
140 reads
Query Post Execution Showplan event is a very useful event to find problematic queries and execution plans based on CPU usage or duration while analyzing performance issues. It can...
2016-05-15
74 reads
In SQL Server, concurrent writes or read / write to the same page can lead to PAGELATCH (like PAGELATCH_EX and PAGELATCH_SH) waits or what is knowns as PAGELATCH contention....
2016-05-15
63 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