FizzBuzz–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-07-24
555 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2017-07-24
555 reads
The whole idea behind databases is to store information, data, in order to look at it later. The place where...
2017-07-24
547 reads
We are having an extra Louisville SQL Server and Power BI User Group meeting this month due to the SQL...
2017-07-24
420 reads
One of the biggest differences with managing SQL Server Linux is with drive presentation. With Windows, we’d all scream if...
2017-08-09 (first published: 2017-07-24)
1,663 reads
I’ll be speaking at two New England area SQL Server user groups in the next few days! First, tonight I’ll...
2017-07-24
308 reads
Looking at what a job has been doing is important. Particularly if something is going wrong. Now there are several...
2017-07-24
470 reads
This is the reality of learning newer tech somewhat in depth and working with it. What this series of posts...
2017-07-24
197 reads
This is the reality of learning newer tech somewhat in depth and working with it. What this series of posts...
2017-07-24
393 reads
On Thursday evening I attended the joint London WinOps and PowerShell User Group. It was an excellent evening with two...
2017-07-24
433 reads
In this video I talk you through installing SQL Server 2017 RC1 on Windows Server 2016 virtual machine. It’s a...
2017-07-24
465 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