Day 4 of 31 Days of Disaster Recovery: Back That Thang Up
Day 4 of 31 Days of Disaster Recovery: Back That Thang Up
31 Days of Disaster Recovery
Here we are at day...
2013-01-04
1,051 reads
Day 4 of 31 Days of Disaster Recovery: Back That Thang Up
31 Days of Disaster Recovery
Here we are at day...
2013-01-04
1,051 reads
Below is the formula of calculating the row size of non-clustered index page
so unique non-clustered index created on unique clustered index use smallest...
2013-01-04
1,209 reads
I’ve been accepted to speak at SQL Saturday #183 in Albuquerque, NM on Feb 9, 2013. This is the first...
2013-01-04
1,170 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-01-04
1,042 reads
With the year 2012 now in the rear view mirror, and while I’m still in the midst of my holiday...
2013-01-04
841 reads
I have been doing some work on some LinkedIn groups that I manage and look after over the holidays. There...
2013-01-04
873 reads
We all know that SQL Server can have 1 default instance & many named instance.
But I want to check, How SQL...
2013-01-04
1,213 reads
As I'm sure I must have mentioned in the past, I’m presently involved in a large ALM project at a...
2013-01-04
1,539 reads
Day 3 of 31 Days of Disaster Recovery: Determining Files to Restore Database
31 Days of Disaster Recovery
Welcome back for day...
2013-01-04
2,321 reads
Calculated Field has existed in Reporting Services since version 2005. SSRS 2005 did not have the most attractive user interface...
2013-01-04
11,504 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