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
“Rob? Tsk tsk tsk. That’s a naughty word. We never rob. We just sort of borrow a bit from those...
2013-01-03 (first published: 2013-01-02)
1,614 reads
Today is the first full work day for me in 2013 and I though I’d use it to write a...
2013-01-02
740 reads
Database Normalization (some useful links)
http://www.ischool.utexas.edu/~wyllys/DMPAMaterials/normstep.html
http://www.guru99.com/database-normalization.html
http://www.aliencoders.com/content/basics-normalization-examples
SQL Server Programming Fundamentals (some useful links)
http://www.blackwasp.co.uk/SQLProgrammingFundamentals.aspx
http://beginner-sql-tutorial.com/sql-select-statement.htm
SQL Server Database Administration
DBA Responsibilities
http://www.bradmcgehee.com/2011/12/the-day-to-day-tasks-of-the-average-dba/
DBA Best Practices
http://www.bradmcgehee.com/presentations/
Free eBooks (to...
2013-01-02
3,436 reads
Introduction Welcome back for the 38th installment in the wildly popular blog party for the SQL Server community. This is the party that happens on the second Tuesday of...
2013-01-02
13 reads
Introduction
Welcome back for the 38th installment in the wildly popular blog party for the SQL Server community. This is the...
2013-01-04 (first published: 2013-01-02)
1,587 reads
Over the past few weeks, I’ve been watching some videos from this year’s PASS Summit. One of the presentations I...
2013-01-02
4,019 reads
You can use the sp_spaceused system-stored procedure to return space usage information about a database or a table within a...
2013-01-02
1,537 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
Yesterday (January 1) I received the email indicating I was re-awarded as a Microsoft MVP, once again in SQL Server....
2013-01-02
1,202 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