Documenting your Tabular or Power BI Model
If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them...
2016-10-05
1,419 reads
If you were used to documenting your SSAS model using the MDSchema rowsets, you might have noticed that some of them...
2016-10-05
1,419 reads
In the previous post (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2016/09/30/say-hello-to-sql-live-health-check-part-1/) I talk about the main screen where you can have a single glance of the...
2016-10-05
1,351 reads
If you have just begun using SQL Server 2016 or you have been using it for a while now you...
2016-10-05
3,123 reads
Problem
A common misconception that i've heard a few times around backups is that a FULL backup invalidates previous TRANSACTION LOG...
2016-10-04
339 reads
In this module you will learn how to use the Chiclet Slicer Power BI Custom Visual. The Chiclet Slicer is...
2016-10-04
983 reads
It’s another week of travel for me, starting early this morning. This is another crazy trip, and yes, I did...
2016-10-04
409 reads
Last year I published an article on SQLServerCentral from Guarab Vohra on using SQL Prompt with a VCS. I really...
2016-10-04
658 reads
In our earlier blog we discussed an introduction to MongoDB. so, how is MongoDB is into BigData, MongoDB has a...
2016-10-04
489 reads
I’ll be delivering two webinars for MSSQLTips.com in the coming months. The first one is about the – amazing – new features...
2016-10-04
598 reads
Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting...
2016-10-04
7,287 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