Roll Logs – Backup Recovery
Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....
2013-05-20 (first published: 2013-05-15)
2,045 reads
Rolling log files for a day, especially with 15 or even 5 minute log backups is a pain at best....
2013-05-20 (first published: 2013-05-15)
2,045 reads
There’s no simple way in SQL Server to see the sizes of all the tables and their indexes. Even seeing...
2013-05-15
703 reads
Don’t trust the name of an index to tell you what it is. The name is wrong, or at least...
2013-05-14
1,576 reads
It's T-SQL Tuesday again (Thanks go to Adam Machanic (B/T)) and this month the host is Wendy Pastrick (B/T). Wendy's...
2013-05-14
675 reads
It’s time for T-SQL Tuesday the forty-second, Wendy Pastrick asked that we talk
T-SQL Tuesday!
about our experiences with change in our work lives. I’d...
2013-05-14
590 reads
The Long and Winding Road It is time for another installment in the monthly blog party for SQL Server professionals known as TSQL Tuesday. This month...
2013-05-14
13 reads
The Long and Winding Road
It is time for another installment in the monthly blog party for SQL Server professionals known...
2013-05-14
695 reads
“The Long and Winding Road” is one of my favorite Beatles songs, it reminds me of my dad, he was...
2013-05-14
580 reads
Spring is in the air, I think. With that scent in the air, we have a nice juicy topic coming up this month for any and all that are...
2013-05-14
12 reads
Spring is in the air, I think.
With that scent in the air, we have a nice juicy topic coming up...
2013-05-14
802 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