Last Weeks Top 10 “Reading” Links #17
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-28
977 reads
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2013-01-28
977 reads
Last month I mentioned that I’d like to start including Oracle stuff on this blog. I’m getting back into that...
2013-01-28
715 reads
Compromise is one of those things that makes the world work. I can’t say I’ve always been good at it....
2013-01-28
794 reads
Most DBAs have at least some idea what the system databases are for. Master has the list of databases & logins,...
2013-01-28
961 reads
SSIS is a very powerful tool and can be very fast however I frequently come across situations where performance could...
2013-02-01 (first published: 2013-01-28)
5,196 reads
Friends, As covered in one of my previous blog:
How crawl works in SharePoint ||How indexing work||Basic concept .
We were...
2013-01-28
1,277 reads
When you are troubleshooting, the rule is if you've checked the obvious possibilities and still haven't solved the problem, it's...
2013-01-28
1,682 reads
Roughly a year ago, I implemented currency conversion logic in multidimensional cubes using measure expressions (as well as using the...
2013-01-28
3,889 reads
DBCC Commands:
DBCC commands are most useful for
performance and troubleshooting.
The DBCC Commands are used in Maintenance, Informational use, Validation on a
database,...
2013-01-28
2,102 reads
The majority of SQL Server Replication topologies are based on the Central Publisher model, which is comprised of a single...
2013-01-28
2,093 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