SQL Server 2016 SP1 – A significant change to licencing
A lot has been written about the change of licencing in SQL 2016 SP1. Here's my two-pence worth.
2017-05-17
22 reads
A lot has been written about the change of licencing in SQL 2016 SP1. Here's my two-pence worth.
2017-05-17
22 reads
With so many product options to choose from for building a big data solution in the cloud, such as SQL...
2017-05-17
819 reads
In this module you will learn how to use the Hierarchy Slicer Power BI Custom Visual. The Hierarchy Slicer visual...
2017-05-30 (first published: 2017-05-17)
1,408 reads
I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old...
2017-05-17
2,879 reads
One of the new features included in SQL Server 2017 that Microsoft has detailed here is a new DMF called...
2017-05-17
1,265 reads
InfluxDb & Grafana Series
Running InfluxDb As A Service in WindowsSetting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
InfluxDB And AnnotationsCapturing...
2017-05-29 (first published: 2017-05-17)
4,118 reads
I’d like to say a huge thank you to everyone who read or published a post for T-SQL Tuesday #90....
2017-05-16
436 reads
Watch this week's video on YouTube
Additional performance comparisons available in an updated post.
Starting with the 2016 release, SQL Server offers native JSON support. Although the implementation is not perfect,...
2017-05-16
38 reads
Have you every executed a query in SQL Server Management Studio, looked at the execution plan, and noticed that it...
2017-05-16
423 reads
I am extremely proud to announce that we’re holding the second SQL Server workshop at this year’s VMworld US in Last Vegas on...
2017-05-16
383 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