Rounding Challenges–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-08-18
638 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-08-18
638 reads
Getting PowerShell on Linux Well it’s not just an announcement, you can actually get PowerShell on Linux and MacOS right now from GitHub – here!
Installing PowerShell Once you’ve downloaded...
2016-08-18
26 reads
Getting PowerShell on Linux
Well it’s not just an announcement, you can actually get PowerShell on Linux and MacOS right now...
2016-08-29 (first published: 2016-08-18)
1,496 reads
We’ve been working on this for a while now and I’m excited to announce the merger of Quanta Intelligence and...
2016-08-18
597 reads
Yesterday evening I had the distinct pleasure of presenting at the Jacksonville SQL Server Users Group on some of the...
2016-08-18
445 reads
One of the most popular posts on this bog describes how to enable bitmap scaling is SSMS on high DPI displays,...
2016-08-25 (first published: 2016-08-18)
4,080 reads
Suffering SQL Server Performance Issues?: A story of Olympic sprints and handy SQL Server hints!!!
Usain Bolt, the world’s fastest runner,...
2016-08-18
446 reads
Paradigm Shift! What do I mean by that? Every once in a while a technology comes along and changes the way things are done, moves the bar…well last week...
2016-08-18
17 reads
Paradigm Shift!
What do I mean by that? Every once in a while a technology comes along and changes the way...
2016-08-18
2,205 reads
command line install options
ReadyRoll has some great features, including the ability to use without cost on a build server. If...
2016-08-18
283 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