SQLServer 2008 R2 SP3 released, Now its testing and deployment time!
As promised Microsoft released SQL Server 2008 R2 SP3 last Friday, and now this is your opportunity to test and...
2014-09-29
1,459 reads
As promised Microsoft released SQL Server 2008 R2 SP3 last Friday, and now this is your opportunity to test and...
2014-09-29
1,459 reads
Those Dev’s/UX designers out there at Microsoft seems to be pretty busy as they releasing back to back updates to windows...
2014-08-18 (first published: 2014-08-12)
7,418 reads
This is one of those posts which is pending for a very long time. I was pretty excited when Azure...
2014-06-26
978 reads
SQL Server 2014 is deeply integrated with Windows Microsoft Azure and moving an On-prem database to a Microsoft Azure VM...
2014-04-24 (first published: 2014-04-16)
1,967 reads
Today I noticed couple of changes(Neat changes !) for Data Collector in SQLServer 2014. This post is a detailed walk-through of setting...
2014-04-08 (first published: 2014-04-04)
3,797 reads
Hot cake for the day is SQLServer 2014 RTM bits. Its generally available starting today, and I downloaded a fresh...
2014-04-01
19,257 reads
The cost associated with Outbound Data Transfer is very important when you consider bridging your On-premise network with Windows Azure.
Yes, when I...
2014-03-25 (first published: 2014-03-19)
2,693 reads
I learned something new today while I was listening to one of the courses on corruption authored by the master,...
2014-02-06
1,597 reads
The cached MSI file ‘C:\Windows\Installer\<name>.msi’ is missing !!! This is one error which you don’t want to see when you are...
2014-01-14
1,226 reads
Apparently,setting up the Min and Max Memory setting for SQLServer should be definitely encouraged and no server should be left...
2014-01-02
842 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