Best Tools for Taking Notes In Development
------------ UPDATE: 2016-04-08 10:12 ------------
Been working through some issues with Clarify app on my personal computer, something I messed up. @trevordevore...
2015-10-14
287 reads
------------ UPDATE: 2016-04-08 10:12 ------------
Been working through some issues with Clarify app on my personal computer, something I messed up. @trevordevore...
2015-10-14
287 reads
I’ve put this off for too long. It’s time to get my feet wet with some new tech.
Step 1 is...
2015-10-14
569 reads
A couple weeks ago in a recent update to Power BI, an enhancement was added to enable a drill-down action...
2015-10-14
424 reads
A couple weeks ago in a recent update to Power BI, an enhancement was added to enable a drill-down action...
2015-10-14
2,048 reads
There needs to be a more efficient means of grabbing the file without having to know the location. Knowing the session name should be adequate enough to parse the...
2015-10-14
17 reads
In the previous article I covered the basics on extracting the payload for the events in a session from the event_file...
2015-10-14
862 reads
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any...
2015-10-14
44 reads
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning for a long time and did not cause any...
2015-10-14
88 reads
It’s quite an unpleasant thing that we had to face once. There was a working script, which had been functioning...
2015-10-14
1,667 reads
I spent the last few weeks travelling a lot compared to my usual routine and I got quickly fed up...
2015-10-14
41,365 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