SQL Server – Script to generate Read-Only Routing URLs
If you are familiar with the new feature Read-Only Routing introduced in SQL Server 2012 with AlwaysOn then you should...
2015-10-01
521 reads
If you are familiar with the new feature Read-Only Routing introduced in SQL Server 2012 with AlwaysOn then you should...
2015-10-01
521 reads
Replication is still a major component of SQL Server today even with Availability Groups as an alternative to certain scenarios....
2015-10-01
706 reads
It’s been a while since my last pre-con, in fact it’s been a while since my last SQL Saturday with...
2015-10-01
548 reads
October is going to be a very busy month for me! Three conferences and a pre-con are on the agenda.
This...
2015-10-01
380 reads
This weekend I’ll be traveling to Kansas City, Missouri for their annual SQL Saturday. Normally, I would just drive to this...
2015-10-01
469 reads
SQL Server Days 2015 is over and it was a blast. Met a lot of people from the #sqlfamily, too...
2015-10-01
587 reads
SQL 2016 is right around the corner and one of the new security enhancements promised is Row-Level security for tables....
2015-10-01
1,319 reads
In the case of the final core component, Targets, the exploration into the metadata can be a little awkward. At least at first. Read on to see how to...
2015-10-01
18 reads
With the ability to find the metadata for deployed session, events and actions firmly under the belt, the natural progression...
2015-10-01
749 reads
Forgot to post the next day and now missing details! Notes:
Rained the entire drive up (and back)Not a bad drive...
2015-09-30
951 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,...
Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec. Cilandak, Kota...
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