Reblog: February 15 to February 21
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-22
922 reads
Welcome to this Friday’s reblog summary post. The aim of these posts is to bring some old posts that newer...
2013-02-22
922 reads
Welcome to Day 22 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-03-04 (first published: 2013-02-22)
3,180 reads
I just read a great article on NetworkWorld that demonstrates that Microsoft’s Azure outperforms most tests against Amazon’s AWS. That’s great...
2013-02-22
738 reads
Wouldn’t it be nice if you had a chance to try out the features of SQL Server? Maybe give them...
2013-03-01 (first published: 2013-02-21)
4,288 reads
Here are the presentation materials for today’s Pragmatic Works Training on the T’s session What Are You Waiting For – Explanation of...
2013-02-21
567 reads
Sometimes you just want to have a look at the system performance, or you feel tired with log on the server, open...
2013-02-21
2,155 reads
I have been selected to present at the SQL Saturday in Chicago on April 13th. This works out nicely as the...
2013-02-21
964 reads
Welcome to Day 21 of my “A Month of PowerShell” series. This series will use the series landing page on...
2013-02-28 (first published: 2013-02-21)
2,615 reads
Friends, do every time we need the GUI ? or we feel the need of Customized things some times in life....
2013-02-21
1,153 reads
by Steve Bolton
In last week’s edition of this amateur series of self-tutorials[i] on SQL Server Data Mining (SSDM), we...
2013-02-21
2,046 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