Session Action Metadata
In a previous article, I introduced the core concept of Actions. In that article, I explained that an Action is...
2015-09-30
1,155 reads
In a previous article, I introduced the core concept of Actions. In that article, I explained that an Action is...
2015-09-30
1,155 reads
SQL Server 2016 CTP 2.4 hasn’t been released yet (any day now I guess), but someone was apparently very eager...
2015-09-30
2,177 reads
I was recently asked how to update views. Specifically the question was about using triggers to update a view.
So...
2015-10-12 (first published: 2015-09-30)
3,135 reads
Utility link for excel import to SQL
Save Excel Data into Databases
http://www.savetodb.com/Connect to databases, edit data, and save changes back. Edit data...
2015-09-30
448 reads
TweetG’day,
I really am going to make an effort to blog more, and this post is really the start of that.
I...
2015-09-30
1,205 reads
Recently, there are lots of questions about SQL licenses, many of them came from the fact that they starting to upgrade to 2012/2014 from their old 2005 servers as...
2015-09-30
34 reads
In T-SQL and other languages we have bitwise XOR natively supported; the T-SQL operator is simply ^. Here’s the explanation of...
2015-10-08 (first published: 2015-09-29)
3,194 reads
SQL Saturday #442 is upon us and yours truly will be presenting in Orlando, Florida on October 10th alongside Mitchell...
2015-09-29
1,037 reads
I first blogged about Microsoft’s new product, the Azure Data Lake, a few months back (here). There are already enhancements, as...
2015-09-29
1,180 reads
Last week we received the results of the PASS Board of Directors elections for 2015. Jen Stirrup and Tim Ford...
2015-09-29
823 reads
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...
By ReviewMyDB
Part 1 of my What's New in SQL Server for the Developer series. IIF,...
Talavera Office Park, Jl. TB Simatupang No.Kav. 26, RT.1/RW.1, Cilandak Bar., Kec. Cilandak, Kota...
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