Marketing Ideas for Chapters & SQLSaturday
I’m part of the team putting together SQLSaturday #151 in Orlando this year, and one of the things Kendal Van...
2012-05-23
733 reads
I’m part of the team putting together SQLSaturday #151 in Orlando this year, and one of the things Kendal Van...
2012-05-23
733 reads
When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...
2012-05-22
38 reads
Suppose you had some data like this:
Class Limit
————— ———–
Calculus 5
History 4
Physics 2
But what you really want is this:
Class ...
2012-05-22
1,475 reads
The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed. ...
2012-05-22
9,615 reads
Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)
As stated earlier on blog on “LocalDB” discussion, developers are involved...
2012-05-22
912 reads
There are some things that we do in one SQL Server tool, but can't seem to figure out how to do in another. One of those for you might...
2012-05-22
41 reads
I am wrapping up this series by finally considering the rarely used type 3 SCD.
( i.e. in most business scenarios)
Unlike...
2012-05-22
865 reads
I received an email from LinkedIn suggesting that I might find these groups useful:
I’m sure those map back to someone...
2012-05-22
732 reads
There are some things that we do in one SQL Server tool, but can't seem to figure out how to...
2012-05-23 (first published: 2012-05-22)
21,117 reads
Microsoft has released two new Cumulative Updates for SQL Server 2008 today. The first one is SQL Server 2008 SP3...
2012-05-21
2,037 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