Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database
Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database
31 Days of Disaster...
2013-01-02
1,783 reads
Day 2 of 31 Days of Disaster Recovery: Protection From Restoring a Backup of a Contained Database
31 Days of Disaster...
2013-01-02
1,783 reads
Tempdb Contention That Can’t be Soothed By Adding Files
Tempdb Contention via Idera diagnostic manager
I’ve talked a lot in the past...
2012-12-21
1,468 reads
Cross-database Queries by Contained Users
http://www.necromaticmedia.com/2007/11/containment/
I presented to the Pacific Northwest SQL Server User Group / PASS Chapter (PNWSQL) last night on...
2012-12-14
1,692 reads
Recent Presentation Session Files
Session Files – A Little Behind
I’ve been a little tardy about getting my session files posted, and I’m...
2012-11-15
892 reads
T-SQL Tuesday #36 – SQL Community
T-SQL Tuesday #36 - SQL Community
This blog entry is participating in T-SQL Tuesday #36, hosted this month...
2012-11-13
972 reads
Don’t Be That PASS Summit Guy
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is just around the corner. Every year...
2012-10-22
1,211 reads
Man Vs Machine
Man Vs Machine
Are you a fan of the television show Man Vs Food starring foodie Adam Richman? In...
2012-08-23
1,089 reads
Why Attending a Monday Pre-con Will Be Awesome
PASS Summit 2012 Speaker
The SQL PASS Summit 2012 is coming up in a...
2012-07-16
1,145 reads
Performing Fast Searches of Query Plans
XML: Fast as a Turtle
I've made blog posts in the past on using the exist()...
2012-07-12
1,357 reads
Is SELECT Identity() … INTO Minimally Logged in Simple Recovery?
Extreme Logging
I was having a discussion with Idera (@idera_software) dev lead Vicky...
2012-06-30
2,222 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