2016-01-15
21 reads
2016-01-15
21 reads
This is a temporary post that was not deleted. Please delete this manually. (c6d728fb-93d8-4ec0-a66c-6dd5e7281550 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2016-01-14
455 reads
The requirement is to check only those services where startup mode set to Auto and services that stopped. In my...
2016-01-14
632 reads
I had someone email me and ask how they could change the IP address on their Availability Group Endpoint. It’s...
2016-01-26 (first published: 2016-01-14)
1,545 reads
I was reading some code the other day and it included the statement RESULT SETS. I’d never seen it before...
2016-01-26 (first published: 2016-01-14)
8,331 reads
Yesterday, on the 13th of January 2016, my blog has reached it’s 10th anniversary. It all started precisely 10 years...
2016-01-14
454 reads
I saw someone mention recently that you can run a REBUILD on a heap table. I hadn’t realized that, but...
2016-01-14
1,785 reads
By Steve Bolton
…………Throughout most of this series of amateur self-tutorials, the main topic has been and will continue to be...
2016-01-25 (first published: 2016-01-13)
1,980 reads
Most of us are aware of Statistics in SQL Server and its purpose. But still, just to get started, statistics...
2016-01-25 (first published: 2016-01-13)
3,241 reads
Code Coverage
What is code coverage?
When you write some code and then test it, how sure are you that you have...
2016-01-22 (first published: 2016-01-13)
2,080 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