Using Team Foundation Service
Team Foundation Service (TFS) is the “cloud” version of Team Foundation Server 2012. Up to 5 users are free, plus for a...
2013-02-19
1,295 reads
Team Foundation Service (TFS) is the “cloud” version of Team Foundation Server 2012. Up to 5 users are free, plus for a...
2013-02-19
1,295 reads
Welcome to Day 19 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-19
704 reads
VM snapshots are the best individualization feature since sliced vBread (yeah, I’m a geek). But…have you ever had a VMware snapshot grow...
2013-02-19
1,088 reads
I don’t! There’s no such thing as multitasking. At least, not how most of us think about it……
Being successful as...
2013-02-19
971 reads
Last week I ran across a blog post by Axel Achten (B|T) that outlined a few reasons why you should...
2013-02-19
1,480 reads
Finding database creation time is simple if database has not been detached from server. You can find database creation time...
2013-02-19
790 reads
This past weekend was SQL Saturday #198 in Vancouver, B.C. It started off with a leisurely drive up to Vancouver...
2013-02-19
1,259 reads
Ever have your SQL Server slow down for reasons that you can’t explain? Or did you spend all night tuning...
2013-02-18
582 reads
Our sessions were not chosen for neither SQLSaturday nor SQLBits but if you were interested; nothing is lost as now...
2013-02-18
730 reads
Every day, I link out a few blogs posts and articles that I’ve read or used from across the internet....
2013-02-18
600 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