Maintenance Plan Owner
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times...
2012-06-25
21 reads
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit some things that are not so good. Other times...
2012-06-25
21 reads
We all inherit things from time to time through our profession. Sometimes we inherit some good things, sometimes we inherit...
2012-07-02 (first published: 2012-06-25)
4,538 reads
I’ve been doing a fair bit of research and investigation into the behavior of the plan cache recently. So I was concerned...
2012-06-28 (first published: 2012-06-25)
3,820 reads
It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting...
2012-06-25
434 reads
It seems just yesterday that we were all in Seattle together, getting a crash course in what’s new and exciting...
2012-06-25
647 reads
Two days back one of my colleque came to me and started complaining about the performance of an Stored Procedure....
2012-06-29 (first published: 2012-06-25)
9,022 reads
When we first announced the return of SQLSaturday to NYC (after 2 long years), we knew we'd get a decent...
2012-06-27 (first published: 2012-06-24)
2,278 reads
SQL Server 2012 allows you to store file/directories in a special table called FileTable that builds on top of SQL...
2012-06-24
13,808 reads
A surrogate key is an auto generated value, usually integer, in the dimension table. It is made the primary key...
2012-06-28 (first published: 2012-06-24)
7,790 reads
This presentation gives an excellent overview of the process of upgrading SQL Server 2008 SSIS packages to work with SQL...
2012-06-24
1,318 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