Cluster failover fails
you may get an error while trying to failover to another node cluster. to resolve this issue create an alias...
2013-10-16
898 reads
you may get an error while trying to failover to another node cluster. to resolve this issue create an alias...
2013-10-16
898 reads
You may get an error on log reader agent failed with following error: Cannot execute as the database principal because...
2013-10-16
841 reads
At the PASS Summit keynote today Quentin Clark announced that SQL Server CTP2 (which is public and the last public review) and is available right now to download here....
2013-10-16
28 reads
One of the items that came up for discussion at the Chapter meeting today was the privacy policy for SQLSaturday....
2013-10-15
311 reads
Started today with breakfast with the family after packing up all their clothes and stuffed animals for the trip home....
2013-10-15
430 reads
Weather a bit cloudy today, a little rain and a little cool – not Seattle, but not Orlando either! Breakfast at...
2013-10-15
459 reads
I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this...
2013-10-15
1,331 reads
sys.dm_io_pending_io_requests DMV (Dynamic Management View), described by BOL as follows: http://msdn.microsoft.com/en-us/library/ms188762.aspx
Returns a row for each pending I/O request in SQL...
2013-10-15
1,398 reads
Are you attending the SQL PASS Summit conference in Charlotte, NC this week? If so, let’s meet up! If not,...
2013-10-15
912 reads
This year I was honored to be selected by Dell Software to present a ten minute session in their booth...
2013-10-15
1,120 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,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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