ScriptDom Visualizer V2
I have made a few ui changes to this to make it a little more usable, I can’t really think...
2015-11-06
27 reads
I have made a few ui changes to this to make it a little more usable, I can’t really think...
2015-11-06
27 reads
I ran into Ed Leighton-Dick last week at the PASS Summit and we were chatting about the SQLNewBlogger challenge he...
2015-11-13 (first published: 2015-11-06)
1,028 reads
In the latest Power BI Desktop a new Preview features was released that now allows you to connect using DirectQuery...
2015-11-06
1,980 reads
Hi all
i have posted quite a few blogs till now, all of them were individual post except a short series...
2015-11-06
394 reads
Finding a row count in a "in memory" Hekaton table can be a tricky task as the regular commands and...
2015-11-06
958 reads
This is probably the last contributor that I am going to add to the DacFx deployment contributors project (https://github.com/DacFxDeploymentContributors/Contributors/) for...
2015-11-06
399 reads
This is probably the last contributor that I am going to add to the DacFx deployment contributors project (https://github.com/DacFxDeploymentContributors/Contributors/) for a little while, if anyone else has one they...
2015-11-06
12 reads
This is probably the last contributor that I am going to add to the DacFx deployment contributors project (https://github.com/DacFxDeploymentContributors/Contributors/) for...
2015-11-06
31 reads
This is probably the last contributor that I am going to add to the DacFx deployment contributors project (https://github.com/DacFxDeploymentContributors/Contributors/) for...
2015-11-06
34 reads
Another day another deployment contributor for the project: https://github.com/DacFxDeploymentContributors/Contributors.
This one came about because I was talking to Peter Schott (b|t)...
2015-11-05
368 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