The Failed Job
I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the...
2013-11-15 (first published: 2013-11-07)
1,680 reads
I was looking into a failed job on a SQL Server 2008R2 instance. My first step was to check the...
2013-11-15 (first published: 2013-11-07)
1,680 reads
It seems like I am going to write another none SQL stuff again. No. This is a real life scenario. I am writing an ETL for my customer to...
2013-11-07
25 reads
It seems like I am going to write another none SQL stuff again. No. This is a real life scenario....
2013-11-07
1,238 reads
On Tuesday I gave a webcast along with MSSQLTips on SQL Injection. If you were unable to attend (or were...
2013-11-07
369 reads
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2013-11-07
366 reads
While the tabular model in SSAS makes it much easier to build cubes than the multidimensional model, I am not...
2013-11-07
22,760 reads
As my first post, I thought I’d list a few points that I would say to any new DBA. I’ll...
2013-11-07
813 reads
I’ve been wanting to do more with Powershell (PoSh). I’ve seen Allen White present on it for years, and I’ve...
2013-11-07
1,419 reads
We all love our databases. We trust everything they do! How could we not? It's our baby.... well, probably not....
2013-11-07
331 reads
On Tuesday I gave a webcast along with MSSQLTips on SQL Injection. If you were unable to attend (or were...
2013-11-07
1,697 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