Resolve Microsoft SQL Server Error Code 824
Since data consistency is a crucial aspect for every user, the server has in-built mechanism which helps to maintain the...
2016-09-01 (first published: 2016-08-23)
3,151 reads
Since data consistency is a crucial aspect for every user, the server has in-built mechanism which helps to maintain the...
2016-09-01 (first published: 2016-08-23)
3,151 reads
If you haven't explored the visual color coding of tabs based on pattern matches with SQL Prompt, I'd suggest you...
2016-08-23
235 reads
I will be presenting my third SQLSaturday session at the upcoming Pittsburgh #545 Saturday, Aug. 13th, 2016. My session, Stretch Database and Managed Backups: Cloud Services for your SQL...
2016-08-23
13 reads
I will be presenting my third SQLSaturday session at the upcoming Pittsburgh #545 Saturday, Aug. 13th, 2016.
My session, Stretch Database...
2016-08-23
192 reads
A couple years I was looking for a new laptop bag. I settled on the Everki Versa, which I’ve been...
2016-08-23
1,193 reads
If you haven't explored the visual color coding of tabs based on pattern matches with SQL Prompt, I'd suggest you...
2016-08-23
1,128 reads
If you have followed my blog for the past year or so you may remember when I posted a Power...
2016-09-01 (first published: 2016-08-23)
3,121 reads
There is greatness within you whether you believe it or not. Over the years there are certain skills that have...
2016-08-31 (first published: 2016-08-23)
2,282 reads
This year has been a whirlwind so far, thanks to the Idera ACE program. For those that don’t know what...
2016-08-23
296 reads
Here we are, 7 years working with SQL Server and Microsoft BI tools. Sure in the grand scheme of things...
2016-09-02 (first published: 2016-08-23)
2,143 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