T-SQL Code Coverage in SSDT using the SSDT Dev Pack
Code Coverage What is code coverage? When you write some code and then test it, how sure are you that you have tested the whole thing? Code coverage gives...
2016-01-13
16 reads
Code Coverage What is code coverage? When you write some code and then test it, how sure are you that you have tested the whole thing? Code coverage gives...
2016-01-13
16 reads
Code Coverage What is code coverage? When you write some code and then test it, how sure are you that...
2016-01-13
75 reads
Code Coverage What is code coverage? When you write some code and then test it, how sure are you that...
2016-01-13
57 reads
If you missed it last week, Microsoft released a Service Update for Power BI , and a long awaited feature is...
2016-01-22 (first published: 2016-01-13)
2,267 reads
I’ve been using a series of web sites while I was starting the process of learning R. I’ve highlighted several...
2016-01-13
598 reads
Verifying Instant File Initialization
Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization...
2016-01-13
261 reads
Hi Guys,
In the previous blog I took you through PowerShell basics We know that PowerShell to works with different modules...
2016-01-21 (first published: 2016-01-13)
2,599 reads
Ran into a few issues verifying instant file initialization. I was trying to ensure that file initialization was enabled, but...
2016-01-13
328 reads
This is one of the hot topic within the DBA community, what should be the best setting for parallelism in your environment? The answer is – it depends! J
Let’s...
2016-01-13
94 reads
T-SQL Tuesday is here again. This month the host is Robert Davis (b | t)
The topic for T-SQL Tuesday #74 is...
2016-01-12
461 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