Nacho Mama’s Training Class
That is what I wanted to name the new training series that we developed at my employer, Perpetual Technologies (PTI.net)....
2012-08-09
1,029 reads
That is what I wanted to name the new training series that we developed at my employer, Perpetual Technologies (PTI.net)....
2012-08-09
1,029 reads
A blog post about Microsoft Assessment Planning Toolkit was in my list for quite a while and today I decided to write...
2012-08-08
932 reads
I just finished the draft schedule for SQLSaturday #151 in Orlando and wanted to write some notes about the process....
2012-08-08
471 reads
Let me set the scene, one of our internal IT SQL Servers which stores a whole host of performance metrics...
2012-08-08
1,856 reads
Date: September 22, 2012
Title: So I started this blog…now what?
Abstract:
Ever thought about trying your hand at blogging? Or maybe you’ve...
2012-08-08
602 reads
I talk a lot about compression. I’ve blogged a pretty decent amount on it as well. One of the things...
2012-08-08
8,063 reads
we often face a situation to move SQL server object beween servers or databases, when you have constant table list...
2012-08-08
5,604 reads
Somehow I missed this gem that’s been around for quite a while so I thought I would share it in...
2012-08-08
2,410 reads
Since I am a bit of a hardware enthusiast, I tend to buy new computer hardware a little more often...
2012-08-07
2,057 reads
In a recent post I talked about how to create a DDL trigger. You’d think to drop that trigger, I’d...
2012-08-07
955 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