DBA Myths: You can only restore one differential backup
Ok, I know I’m hosting T-SQL Tuesday this month but I still had post I wanted to share.
The basic steps...
2016-12-13
482 reads
Ok, I know I’m hosting T-SQL Tuesday this month but I still had post I wanted to share.
The basic steps...
2016-12-13
482 reads
It’s T-SQL Tuesday time, and this month Ken Fisher hosts. His topic is backups, and while I’m sure there will...
2016-12-13
618 reads
In this module you will learn how to use the Dial Gauge Power BI Custom Visual. While the usefulness of...
2016-12-13
614 reads
I like ReadyRoll, and this week at SQL in the City 2017, I get to show some of the product...
2016-12-13
445 reads
One of my favorite testing features of SSIS is also one of the most underutilized. SSIS data taps were introduced...
2016-12-13
425 reads
Shout out to Kenneth Fisher (b|t) for hosting this month's #tsql2sday. This month is about backup and recovery and here...
2016-12-13
290 reads
Following on from my previous post on NOLOCK (https://blobeater.blog/2016/12/09/nolock/) I want to talk about another hint called READPAST. This hint tells...
2016-12-13
469 reads
Don’t trust Invoke-SqlCmd and error results
I love to call Invoke-sqlcmd from powershell but one must beware of the risk of...
2016-12-13
67 reads
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s...
2016-12-12
91 reads
I’ve been wanting to demo cool-easy ways to do things in SSAS with PowerShell for a long time but haven’t gotten around to working on it much. Well, it’s...
2016-12-12
36 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