Cyber Monday: Performance Indexing Book is $15
Ever thought you could learn a little bit more about indexing? Now here’s the perfect opportunity. Today only you can...
2012-11-26
824 reads
Ever thought you could learn a little bit more about indexing? Now here’s the perfect opportunity. Today only you can...
2012-11-26
824 reads
I like to repost this blog about once a year, because you really really need to know about windowing functions....
2012-11-28 (first published: 2012-11-26)
4,625 reads
A special thanks goes to Daniel Angerer (t) for suggesting an improvement that corrected the divide by zero error that one...
2012-11-26
1,242 reads
Throughout the week, I like to tweet links to the things that I’ve been reading. Since they all come out through out...
2012-11-26
641 reads
Every time you run the SkyDrive Client on your device, a laptop in my case, all your files from the cloud are downloaded to...
2012-11-26
983 reads
Last weekend I was in Tampa for SQLSaturday #168 and made sure to make some time for family. The most...
2012-11-26
914 reads
Hey Friends,
Sometime when we try to access central administration and certain tabs like operation and Application management we face issues....
2012-11-26
510 reads
The impact of having data sitting in the distribution database that doesn’t need to be there can be significant. The...
2012-11-26
4,132 reads
In this article, We are going to CREATE/ ALTER/ DROP a table and observe transaction log records created for those DDL statements.
Our...
2012-11-26
3,560 reads
Query Performance Tuning. Grant Fritchey. $15. If this doesn’t excite you, nothing will. Apress is offering every e-book for just $15...
2012-11-26
1,003 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