Is your LOG backed up?
You have been doing a fantastic job of late. You have all of your databases being backed up on a regular schedule. Now you get an alert that your...
2013-02-11
13 reads
You have been doing a fantastic job of late. You have all of your databases being backed up on a regular schedule. Now you get an alert that your...
2013-02-11
13 reads
You have been doing a fantastic job of late. You have all of your databases being backed up on a...
2013-02-12 (first published: 2013-02-11)
1,659 reads
I doubt you noticed but I took a few weeks to relax, so no tech for me. Last week my...
2013-02-11
902 reads
Microsoft SharePoint Server 2010 provides several options for creating Dashboards using PerformancePoint content.
The first option is to implement the...
2013-02-11
3,584 reads
The SQLSoldier World Tour kicks off this next Friday when I head up to Vancouver, in British Columbia, Canada. I...
2013-02-10
1,105 reads
Welcome back for day 26 of my series 31 Days of Disaster Recovery. Today I want to share a tale...
2013-02-10
1,132 reads
Welcome to Day 10 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-13 (first published: 2013-02-10)
2,738 reads
My series 31 Days of Disaster recovery has been on hiatus due mostly to illness. I’ve been battling a chest...
2013-02-10
1,305 reads
Ever since it was announced I’ve been ambivalent about the PASS Business Analytics Conference. I believe PASS should look for...
2013-02-09
855 reads
Welcome to Day 9 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-09
6,069 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