How to Edit Read-Only Non-clustered Columnstore Data
As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...
2014-08-06 (first published: 2014-07-29)
8,139 reads
As I've discussed in some of my previous posts, creating a non-clustered Columnstore index will make the index as well...
2014-08-06 (first published: 2014-07-29)
8,139 reads
I am not sure how many books by Seth Godin I do own, I guess that it is somewhere around...
2014-08-06
230 reads
What
When you use the SchemaBinding keyword while creating a view or function you bind the structure of any underlying tables...
2014-08-06
1,137 reads
The other day a secondary family member said “we’re still on Microsoft 2010”. Another said “My friend is using Windows...
2014-08-06
556 reads
This is the very first blog post in a new series on the Batch Mode, welcome & enjoy!
I will be going...
2014-08-05
151 reads
No viewed on LinkedIn yesterday. Increased the bid to $5 and now seeing views. Not sure it correlates, but probably....
2014-08-05
753 reads
Join me at SQL Live 360 this November!
I am hugely excited to have been selected to present at Live 360,...
2014-08-05
409 reads
Join me at SQL Live 360 this November!
I am hugely excited to have been selected to present at Live 360,...
2014-08-05
880 reads
Today, We will go through with the steps of renaming or changing SQL Server Standalone Named Instance.
Renaming or Changing SQL...
2014-08-05 (first published: 2014-07-29)
9,160 reads
I have been working on upgrading my laptop. Since my laptop housed a bunch of my virtual machines for various presentations and labs, that means also upgrading and/or converting...
2014-08-05
9 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,...
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...
Comments posted to this topic are about the item Data Lost in the Cloud
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