SQL Skills IE3 #sqlskills
I attended my first SQL Skills event in December 2011. Due to a big project at work I was able...
2012-03-16
723 reads
I attended my first SQL Skills event in December 2011. Due to a big project at work I was able...
2012-03-16
723 reads
A few weeks ago I started clearing space for a small garden. Tedious work due to the area of the...
2012-03-16
933 reads
If you create a maintenance plan (SQL 9.0.3042) to backup databases and select All databases as below;
Then at some point...
2012-03-16
911 reads
Something fun for Friday, this was a gift from the client I work with to lighten things up and do...
2012-03-16
910 reads
Howdy! I was flying last week, and for the first time i sat facing a flight attendant. You don’t actually...
2012-03-16
862 reads
I am currently working on some client servers to upgrade multiple SQL 2008 R2 Express instances to 2008 R2 Standard. ...
2012-03-16
659 reads
It’s the early morning of the 16th, and time to write my #meme15 post. Remember, these are due on or...
2012-03-16
867 reads
It's been an interesting day. It was the 1 year anniversary of SQLSandwiches today. It was also my last day working...
2012-03-16
1,103 reads
Today I’ll be continuing in a blog series designed to help you decide which presentation tool is best for your...
2012-03-21 (first published: 2012-03-16)
2,962 reads
The Merge Join is a Physical Operation when joining 2 sets of data that are in the same order.
There...
2012-03-15
5,914 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