Day 10 of 31 Days of Disaster Recovery: Monitoring for Corruption Errors
31 Days of Disaster Recovery
Itβs day 10 of my 31 Days of Disaster Recovery series, and I want to...
2013-01-11
1,365 reads
31 Days of Disaster Recovery
Itβs day 10 of my 31 Days of Disaster Recovery series, and I want to...
2013-01-11
1,365 reads
31 Days of Disaster Recovery
Welcome to day 9 of my 31 Days of Disaster Recovery series. Today, I want...
2013-01-09
2,240 reads
31 Days of Disaster Recovery
Welcome to day 5 of my series on disaster recovery. I want to start digging...
2013-01-08 (first published: 2013-01-06)
3,184 reads
Day 7 of 31 Days of Disaster Recovery: Writing SLAs for Disaster Recovery
31 Days of Disaster Recovery
Today is day...
2013-01-08
1,612 reads
T-SQL Tuesday #38
This post is not only day 7 of my 31 Days of Disaster Recovery series, it is...
2013-01-08
1,363 reads
Day 6 of 31 Days of Disaster Recovery: Dealing With Corruption in Allocation Pages
31 Days of Disaster Recovery
Yesterday, I...
2013-01-06
1,648 reads
Day 1 of 31 Days of Disaster Recovery: Does DBCC Automatically Use Existing Snapshot?
31 Days of Disaster Recovery
Welcome to my...
2013-01-04 (first published: 2013-01-01)
2,310 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
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,052 reads
SQLBits XI: Need Your Vote
SQL Bits XI
SQLBits XI is in Nottingham, U.K., May 2 β 4, 2013, and I am attending....
2013-01-03 (first published: 2013-01-02)
1,044 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...
Wa:082374977784 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...
Wa:082374977784 Jl. Jenderal Sudirman Lt Dasar, RT.1/RW.3, Gelora, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
Has anyone ever seen this before? I have sysadmin permission on a server. I...
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