PowerShell Virtual Group of PASS February Newsletter
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting...
2017-02-15
496 reads
We had a schedule conflict so today’s meeting will be pushed until next Wednesday. However, we have a last-minute meeting...
2017-02-15
496 reads
SQL folks, upcoming list of webinars from SQL PASS.
Webinar title / Registration link / more infoSpeakerDate / Time"Why Your Data Type Choices Matter" https://attendee.gotowebinar.com/register/4226815545680860675Andy...
2017-02-15
261 reads
I’ve been going over some demos for a presentation that I’ll be giving this year and I thought I’d write...
2017-02-15
440 reads
Continuation from the previous 97 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing with the spirit of the previous...
2017-02-15
475 reads
I’ve been testing and working with SQL Clone for the last few months, trying to help the devs at Redgate...
2017-02-20 (first published: 2017-02-15)
1,633 reads
Logging into the Azure portal is a daily task of mine and my eyes light up when I see features...
2017-02-15
344 reads
T-SQL Tuesday is a monthly event where SQL Server bloggers write a post based on a subject chosen by the...
2017-02-21 (first published: 2017-02-14)
6,960 reads
Today is yet another T-SQL Tuesday – the monthly blogging party started by Adam Machanic (b|t) to get everyone in the...
2017-02-14
451 reads
Welcome to T-SQL Tuesday #87 being hosted this month by Matt Gordon (blog|@sqlatspeed). This month’s topic is “Fixing Old Problems...
2017-02-14
701 reads
Thanks to Matt Gordon (@atsqlspeed) for hosting this T-SQL Tuesday.
Splitting Strings in SQL
A problem that has plagued SQL developers through...
2017-02-14
449 reads
By Steve Jones
I was experimenting with CHOOSE() recently after I was asked a question. In a...
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...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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...
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