How to sign a SQL Server CLR Assembly in Visual Studio 2015
It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR...
2017-02-22 (first published: 2017-02-21)
6,889 reads
It took me quite a while to figure out how to sign a SQL Server CLR Assembly (like a CLR...
2017-02-22 (first published: 2017-02-21)
6,889 reads
Welcome to the last part of this series, you can find the previous post here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/01/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-1/) and here (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2017/02/08/improve-performance-by-replacing-temp-tables-with-memory-optimized-tables-part-2/).
Previously we...
2017-02-24 (first published: 2017-02-21)
5,105 reads
Since installing SQL Server vNext CTP 1.3 I found out that there is a new way to return statistics histogram...
2017-02-21
384 reads
[2017-Feb-21] I'm creating this particular blog post more for myself to remember and use it as a reference to related discussions...
2017-02-23 (first published: 2017-02-21)
3,347 reads
One question constantly comes up; What should the Cost Threshold for Parallelism be? The default value of 5 is pretty...
2017-02-22 (first published: 2017-02-20)
2,527 reads
Growing up my mother used this phrase quite a bit. Penny wise, pound stupid. (In case you didn’t know the...
2017-02-20
432 reads
I had a need to setup transactional replication from my SQL Server to SQL Database (Azure) where I only needed...
2017-02-20
397 reads
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail over together. An availability group supports a set of...
2017-02-20
44 reads
An availability group supports a failover environment for a discrete set of user databases, known as availability databases, that fail...
2017-02-20
78,268 reads
In my last post, I explained how to alter an existing job step across many servers. I also had cause...
2017-02-23 (first published: 2017-02-20)
3,178 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,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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