Potential Backup Software Issues with Read-Only Databases in FULL Recovery
If you decide to park a database in read-only mode for a long period of time, go ahead and alter...
2013-11-13 (first published: 2013-11-05)
2,040 reads
If you decide to park a database in read-only mode for a long period of time, go ahead and alter...
2013-11-13 (first published: 2013-11-05)
2,040 reads
In the last Tour of the Transaction Log we looked at how INSERT operations behave in the transaction log.
In this...
2013-11-04
566 reads
Upgrading from Power Pivot workbooks to SSAS Tabular models is usually a pretty seamless process. This is part of the...
2013-11-11 (first published: 2013-11-04)
1,855 reads
Yeah, I’m a couple of days late. Tough. My blog. My rules.
Speaking of rules. Speaker of the Month is chosen...
2013-11-04
665 reads
Two weeks ago I presented my session entitled “Squeezing Top Performance from Your Virtualized SQL Server” at the SQL PASS...
2013-11-12 (first published: 2013-11-04)
3,675 reads
These are a couple of stored procedures I wrote to help me with security research. Each sp returns three data...
2013-11-11 (first published: 2013-11-04)
1,868 reads
A couple of weeks ago I wrote a post dispelling the myth that the simple recovery model disables the transaction...
2013-11-04
963 reads
The 9th cumulative update release for SQL Server 2008 R2 Service Pack 2 is now available for download at the...
2013-11-04
1,002 reads
The 10th cumulative update release for SQL Server 2012 RTM is now available. Cumulative Update 10 contains all the hotfixes...
2013-11-04
853 reads
Not too long ago Red Gate asked for quick tips on SQL Server performance intended for developers. I sent a...
2013-11-04
2,532 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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