Monday Morning SQL Break – January 16, 2017
It’s Monday and time, finally, for a weekly blog and twitter round-up for last week. It’s been a while since...
2017-01-16
780 reads
It’s Monday and time, finally, for a weekly blog and twitter round-up for last week. It’s been a while since...
2017-01-16
780 reads
Redgate produces some great software, and I’m glad that I get to use all of them as a developer and...
2017-01-16
507 reads
UPDATE: The SQL Saturday in Chicago this year has hit peak capacity two months before the event! However, if you enroll...
2017-01-16
370 reads
You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up...
2017-01-19 (first published: 2017-01-16)
2,583 reads
I’ve been a scribbler for as long as I can remember, in fact I’m not sure that I write everything...
2017-01-16
356 reads
We all experienced blocking one way or the other, in the old days, the only method is wait J
This is...
2017-01-19 (first published: 2017-01-16)
8,434 reads
1) As MS is kept increasing number of option while installation. To reduce no. of click, if setup pass Rules...
2017-01-16
581 reads
This week we started our Centino Systems weekly newsletter. Check out the first edition here!
The newsletter is going to include the latest in SQL Server and other things in...
2017-01-15
22 reads
This week we started our Centino Systems weekly newsletter. Check out the first edition here!
The newsletter is going to include...
2017-01-15
661 reads
There are many ways to reap benefits from being a member of the PASS Global Community. Today, as I write...
2017-01-17 (first published: 2017-01-14)
1,429 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