Free Tools For The DBA
In this post we will look at 5 free tools that I use on a daily basis, I'll give a...
2013-09-05
1,430 reads
In this post we will look at 5 free tools that I use on a daily basis, I'll give a...
2013-09-05
1,430 reads
Welcome back for day two of this six part series Introduction to Integrity, sponsored by Idera. In this post, I...
2013-09-05
994 reads
When I first heard of the MCM program termination discontent, I reacted by sympathizing with my fellow Database Professionals but...
2013-09-05
977 reads
I recently had the task of collecting job activity for the purposes of turning it into a report for some...
2013-09-05
16,159 reads
A client of mine are looking for a good SQL Server DBA on a permanent basis, the location is flexible...
2013-09-05
717 reads
I’m studying my butt off for the soon-to-be-deprecated Microsoft Certified Master cert’s lab – and the three unfinished prerequisite certs I’ve...
2013-09-05
717 reads
Thanks to everyone who attended my session “Building an Effective Data Warehouse Architecture” for the PASS DBA Fundamentals Virtual Chapter. The abstract is...
2013-09-04
721 reads
But then, the capabilities in Azure are always expanding. Here’s the new stuff that was just released in a blog...
2013-09-04
641 reads
Sorry things are a little later this month…Summer (like the MCM program) may be coming to an end, but we...
2013-09-04
691 reads
(Be sure to checkout the SQLpassion Online Academy, where you get High-Quality SQL Server Trainings with Instant Access!)
People are sometimes...
2013-09-04
876 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